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; }