if ($strPassStatus == "NP") {
             $qryUpdate = "update cs_transactiondetails set nopasscomments = '{$strNoPassReason}' where transactionId={$iTransactionId}";
         }
     }
 }
 if ($qryUpdate != "") {
     //print($qryUpdate);
     if (!mysql_query($qryUpdate, $cnn_cs)) {
         print mysql_errno() . ": " . mysql_error() . "<BR>";
         print "Can not execute query pass update query";
         exit;
     }
 }
 if ($strPassStatus != "" && $strPassStatus != $db_passstatus) {
     if ($strPassStatus == "PA") {
         if ($str_payment_type == "C" && $strBillingDate == $strCurrentDateTime && func_is_auto_approved($cnn_cs, $iCompanyId)) {
             $qryUpdate = "update cs_transactiondetails set status = 'A',approvaldate = '{$strCurrentDateTime}',passStatus = '{$strPassStatus}' where transactionId={$iTransactionId}";
         } else {
             $qryUpdate = "update cs_transactiondetails set passStatus  = '{$strPassStatus}' where transactionId={$iTransactionId}";
         }
     } else {
         $return_insertId = func_transaction_updatenew($iTransactionId, $cnn_cs);
         $passcount = $db_passcount + 1;
         if ($strPassStatus == "NP" && $db_passcount >= 1) {
             $qryUpdate = "update cs_transactiondetails set passStatus  = 'ND',pass_count=" . $passcount . " where transactionId={$return_insertId}";
         } else {
             $qryUpdate = "update cs_transactiondetails set passStatus  = '{$strPassStatus}',pass_count=" . $passcount . " where transactionId={$return_insertId}";
         }
     }
     if ($qryUpdate != "") {
         if (!mysql_query($qryUpdate, $cnn_cs)) {
Esempio n. 2
0
     if ($str_nopass == "Y") {
         if ($str_status_code != "NP") {
             continue;
         }
     }
 }
 $str_exists_query = "select checkorcard,billingDate from cs_transactiondetails where voiceAuthorizationno='{$str_voice_id}' and userid = {$i_company_id}";
 if (!($rstSelect = mysql_query($str_exists_query, $cnn_cs))) {
     dieLog(mysql_errno() . ": " . mysql_error() . "<BR>");
 }
 if (mysql_num_rows($rstSelect) > 0) {
     $str_payment_type = mysql_result($rstSelect, 0, 0);
     $str_billing_date = mysql_result($rstSelect, 0, 1);
     $str_query = "update cs_transactiondetails set ";
     if ($str_status_code == "PA") {
         if ($str_payment_type == "C" && func_is_auto_approved($cnn_cs, $i_company_id)) {
             if ($str_billing_date == $str_current_date) {
                 $str_query .= "status = 'A',approvaldate = '{$str_current_date}',";
             }
         }
     }
     if ($str_status_code == "NP") {
         if ($arr_voice_ids != "") {
             for ($i_loop1 = 0; $i_loop1 < count($arr_voice_ids); $i_loop1++) {
                 if ($arr_voice_ids[$i_loop1] == $str_voice_id) {
                     $str_comments = Trim($arr_comments[$i_loop1]);
                     if (strpos($str_comments, "|") == 0) {
                         $str_comments = substr($str_comments, 1);
                     }
                     //print($str_comments."<br>");
                     break;