<?php

// Check nonce
PHPCUS_PARAM::CUS_REQUIRES_NONCE();

// Dismiss Session
PHPVC_SESSION::VAR_STOP();
	
// Check array size
PHPCUS_PARAM::CUS_ARRAY_TOO_LARGE();

// Check already authenticated
PHPCUS_PARAM::CUS_REQUIRES_AUTHENTICATION();

// Check access rights
PHPCUS_PARAM::CUS_HAS_PERMISSION(PHPCUS_SYSTEM::AUTHORITY_VIEW_EDIT, 'account_group');

if
(
    PHPRC_HTTP_PARAM::REF_ISSET_IN_ARRAY
    (
        [
            'PARAM_ACC_GROUP_ID',
            'PARAM_ACC_GROUP_DESCRIPTION',
            'PARAM_ACC_GROUP_STATUS'
        ], True
        )
    )
{
    Try
    {
        // Read params
        // ------------------------------------------------------------------
        $PARAM_ACC_GROUP_ID = PHPCUS_PARAM::CUS_READ_BIGINT('PARAM_ACC_GROUP_ID', true);
        $PARAM_ACC_GROUP_DESCRIPTION = PHPCUS_PARAM::CUS_READ_NVARCHAR('PARAM_ACC_GROUP_DESCRIPTION', true);
        $PARAM_ACC_GROUP_STATUS = PHPCUS_PARAM::CUS_READ_INT('PARAM_ACC_GROUP_STATUS', true);
        
        $PARAM_ARRAY_COUNT = count($PARAM_ACC_GROUP_ID);
        
        
        // Validate if array has same size
        // ------------------------------------------------------------------
        PHPCUS_PARAM::CUS_ARRAY_SIZE_MISMATCH
        (
            [
                $PARAM_ACC_GROUP_ID,
                $PARAM_ACC_GROUP_DESCRIPTION,
                $PARAM_ACC_GROUP_STATUS
            ]
            );
        
        
        // Prepare PDO Handler
        // ------------------------------------------------------------------
        $FULL_DATA_SET = [];
        $ARRAY_CTR = 0;
        
        $PDO_HANDLE = PHPRC_PDO_MYSQL::REF_CONNECT();
        PHPRC_PDO_MYSQL::REF_TRANSACTION_BEGIN($PDO_HANDLE);
        
        
        // Execute Stored Procedure
        // ------------------------------------------------------------------
        Try
        {
            while($ARRAY_CTR < $PARAM_ARRAY_COUNT)
            {
                $DATA_SET = PHPCUS_ACCOUNT_GROUP::CUS_SAVE
                (
                    $PARAM_ACC_GROUP_ID[$ARRAY_CTR],
                    $PARAM_ACC_GROUP_DESCRIPTION[$ARRAY_CTR],
                    $PARAM_ACC_GROUP_STATUS[$ARRAY_CTR],
                    
                    true,
                    $PDO_HANDLE
                    );
                
                $FULL_DATA_SET = PHPRC_PDO_MYSQL_ARRAY::REF_MERGE($FULL_DATA_SET, $DATA_SET);
                $ARRAY_CTR ++;
            }
            
        }
        Catch(Exception $PDO_ERR)
        {
            PHPRC_PDO_MYSQL::REF_TRANSACTION_ROLLBACK($PDO_HANDLE);
            PHPCUS_PARAM::CUS_JSON_ERROR($PDO_ERR);
        }
        PHPRC_PDO_MYSQL::REF_TRANSACTION_COMMIT($PDO_HANDLE);
        
        
        
        // Return JSON response
        // ------------------------------------------------------------------
        PHPCUS_PARAM::CUS_JSON_SUCCESS($FULL_DATA_SET);
        
    }
    Catch(Exception $ERR)
    {
        PHPCUS_PARAM::CUS_JSON_ERROR($ERR);
    }
}
else
{
    PHPCUS_PARAM::CUS_JSON_ERROR('Missing parameters');
}

?>