vicidial.org

mflorell wrote:Here is a link to the QC manual addendum:

http://www.vicidial.org/docs/Vicidial_Q ... ual_v1.pdf

williamconley wrote:

mflorell wrote:Here is a link to the QC manual addendum:

http://www.vicidial.org/docs/Vicidial_Q ... ual_v1.pdf

spacejanitor wrote:Yes indeed, that is a good way to double-check responses.

Well, I'm generally interested in anything I don't already know As I understand it so far, QC is a buffer system between agent dispositions and client export.

TypeError: parent.document.getElementById(...) is null
[Break On This Error]

parent.document.getElementById('FORM_LOADED').value='1';

TypeError: window.A_TCALSIDX is undefined
[Break On This Error]

for (var i = 0; i < window.A_TCALSIDX.length; i++)

"NetworkError: 404 Not Found - http://200.2.168.154:8082/vicidial/qc/images/cal.gif"

Code: Select all

## Setup (add to top of php file)
define('DEBUG', false);
define('CLIDISPLAY', false);
if (CLIDISPLAY) {
    define('PRE', '');
    define('PRE_END', '');
} else {
    define('PRE', '<pre>');
    define('PRE_END', '</pre>');
}
require_once("../vicidial/dbconnect.php");
$DBLink = new mysqli($VARDB_server, $VARDB_user, $VARDB_pass, $VARDB_database, $VARDB_port);
if ($DBLink->connect_errno) {
    printf(PRE . "Connect failed: %s\n" . PRE_END, $DBLink->connect_error);
    exit();
}
## End setup

# Sample execution
$Query = "select * from vicidial_users where user='6666' and active='Y' limit 1";
$Records = GetData($DBLink, $Query);
print_r($Records[0]); // Single record return access via [0] to access a field named "id": $Records[0]['id']
// Multiple record return access via array walking
foreach ($Records as $Record) {
    print_r($Record);
}
$Query = "update vicidial_users set active='Y' where user='6666' limit 1";
UpdateData($DBLink, $Query);

#Functions (Add to bottom of php file)
function GetData($DBLink, $Query) {
    if (DEBUG) {
        echo PRE . "Query: $Query\n" . PRE_END;
    }
    if ($Result = $DBLink->query($Query)) {
        if (DEBUG) {
            printf(PRE . "Affected rows (Non-Select): %d\n" . PRE_END, $DBLink->affected_rows);
        }
        while ($Record = $Result->fetch_assoc()) {
            $ReturnData[] = $Record;
        }
        return $ReturnData;
    } else {
        if (DEBUG) {
            printf(PRE . "Errormessage: %s\n", $DBLink->error);
            printf("Affected rows (Non-Select): %d\n", $DBLink->affected_rows);
            echo "No Records Returned\n" . PRE_END;
        }
        return false;
    }
}

function UpdateData($DBLink, $Query) {
    if (DEBUG) {
        echo PRE . "Query: $Query\n" . PRE_END;
    }
    if ($Result = $DBLink->query($Query)) {
        if (DEBUG) {
            printf(PRE . "%s\n", $DBLink->info);
            printf("Affected rows (Non-Select): %d\n" . PRE_END, $DBLink->affected_rows);
        }
        return;
    } else {
        if (DEBUG) {
            printf(PRE . "Errormessage: %s\n", $DBLink->error);
            printf("Affected rows (Non-Select): %d\n", $DBLink->affected_rows);
            echo "No Records Returned\n" . PRE_END;
        }
        return;
    }
}


Use the Comment field before submitting (At present these notes will be editable / deletable by the agent).