function get_acct($conn, $ctrlname)
{
$query_get_ctrlno = sqlanywhere_query($conn, "SELECT ctnseqno FROM setControlNo\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE ctnctrlname = '{$ctrlname}'");
// and brno = '$brno'");
if (!sqlanywhere_num_rows($query_get_ctrlno) == 0) {
$row = sqlanywhere_fetch_array($query_get_ctrlno);
$ctrlnumber = $row['ctnseqno'];
$control = $ctrlnumber + 1;
//echo $ctrlnumber."control";
$update_control = sqlanywhere_query($conn, "UPDATE setControlNo SET ctnseqno = '{$control}'\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE ctnctrlname = '{$ctrlname}'");
// and brno = '$brno'");
if ($update_contro) {
sqlanywhere_free_result($update_control);
}
} else {
$insert_control = sqlanywhere_query($conn, "INSERT INTO setControlNo(ctnctrlname, ctnctrldesc, ctnseqno, brno)\n\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES('{$ctrlname}','Filled by Administrator','1','{$brno}')");
$control = 1;
}
return $control;
}
function setSequenceDisburse($user, $brno, $transType)
{
include 'config.php';
$query_get_ctrlno = sqlanywhere_query($conn, "SELECT uscSeqDisbursement FROM usrSequenceControl\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE uscUserName = '******'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND uscBrno = '{$brno}'");
if (!sqlanywhere_num_rows($query_get_ctrlno) == 0) {
$row = sqlanywhere_fetch_array($query_get_ctrlno);
$ctrlnumber = $row['0'];
$control = $ctrlnumber;
if ($transType == 'update') {
$control = $ctrlnumber + 1;
$update_control = sqlanywhere_query($conn, "UPDATE usrSequenceControl SET uscSeqDisbursement = '{$control}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE uscUserName = '******'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND uscBrno = '{$brno}'");
// ");
if ($update_contro) {
sqlanywhere_free_result($update_control);
}
}
} else {
$getTellerNumber = sqlanywhere_query($conn, "SELECT count(*) FROM usrSequenceControl");
$rowTellerNo = sqlanywhere_fetch_array($getTellerNumber);
$totCount = $rowTellerNo['0'];
$totCount = $totCount + 1;
$control = 1;
$insert_control = sqlanywhere_query($conn, "INSERT INTO usrSequenceControl(uscUserName, uscUserNo, uscBrno, uscSeqReceipt, uscSeqDisbursement, uscCashVoucher, uscCheckVoucher, uscSeqJournal )\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES('{$user}', '{$totCount}','{$brno}', 0, '{$control}', 0, 0, 0)");
}
return $control;
}
