$bank_id = $adminInfo['li_bank']; } else { if ($resellerInfo['isMasterMerchant']) { $bank_id = $resellerInfo['rd_subgateway_bank_id']; } else { dieLog("You do not have access to this page."); } } } //$bank_id_sql = " AND bank_id = $bank_id"; if (!$adminInfo['li_show_all_profit']) { $bank_id_sql = " and 0"; } //bank_id = '".$adminInfo['li_bank']."' "; // Calendar View if (beginCacheTable("BI_" . $etel_trans_update_key . "_" . getRequestHash(), time() + 60 * 60)) { $qry_company = "SELECT * FROM `cs_bank` WHERE 1 {$bank_id_sql}"; $bank_details = mysql_query($qry_company, $cnn_cs) or dieLog("Cannot execute query"); //updateCompanyPayStatus(); while ($bankInfo = mysql_fetch_assoc($bank_details)) { unset($bankInfo['bk_defaults']); $bank_options .= "<option value='" . $bankInfo['bank_id'] . "' " . ($bankInfo['bank_id'] == $_REQUEST['bank_id'] ? "selected" : "") . ">" . $bankInfo['bank_name'] . "</option>\n"; $cs_bank_invoice = NULL; $bi_pay_info = NULL; $date_hold = 0; $date_delay = 0; //$bi_pay_info = updateBankInvoice(time()); /* $sql = "SELECT * FROM `cs_bank_invoice` WHERE `bi_bank_id` = '".$bankInfo['bank_id']."' AND `bi_date` between '".date("Y-m-d",$from_date)."' AND '".date("Y-m-d",$to_date)."'"; $result = mysql_query($sql,$cnn_cs); $invoiceNum = mysql_num_rows($result);
.blue { font-size: 12px; color:#0000FF; font-weight: bold; } --> </style> <?php $sql = "SELECT count(`transactionId`) as key1 FROM `cs_transactiondetails` as td, `cs_companydetails` as cd where td.userId = cd.userId AND reseller_id > 0"; $result = mysql_query($sql) or dieLog(mysql_error()); $key = mysql_result($result, 0, 0); if (beginCacheTable("BI_" . $key . "_" . getRequestHash(), time() + 60 * 60)) { ?> <form action="" method="GET" name="FrmMerchant" > <table border="0" align="center" cellpadding="2"> <tr valign="middle" > <td width="102" align="right" valign="middle"><select name="show_rollover" id="show_rollover" > <option value="a" <?php echo $show_rollover == 'a' ? "selected" : ""; ?> >Show All </option> <option value="p" <?php echo $show_rollover == 'p' ? "selected" : ""; ?> >Show Payable Companies</option> <option value="s" <?php