Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <head>
- <link type="text/css" rel="stylesheet" href="../design.css" />
- </head>
- <body>
- <?php
- function inputDate(){
- define('TIMEZONE', 'Asia/Manila');
- date_default_timezone_set(TIMEZONE);
- return date('Y-m-d');
- }
- include 'con_test.php';
- echo "<table name='volCI' cellspacing='0' cellpadding='0' border='1' rules='rows' style='font-family:Calibri; margin:0 auto 0 auto; font-size:15px; text-align:center; padding:4px;'>
- <tr border='1'>
- <th> Products </th>
- <th> Encoding </th>
- <th> File Matching </th>
- <th> Tele CI </th>
- <th> Field CI - Metro</th>
- <th> Field CI - Provincial</th>
- </tr>";
- // START OF AUTO PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Auto'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Auto</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Auto'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Auto'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Auto'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Auto'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF AUTO PRODUCT --------------------------------------------
- // START OF Mortgage PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Mortgage</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF Mortgage PRODUCT --------------------------------------------
- // START OF SME PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>SME</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF SME PRODUCT --------------------------------------------
- // START OF Personal Loan PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Personal Loan'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Personal Loan</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Personal Loan'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Personal Loan'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Personal Loan'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Personal Loan'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF Personal Loan PRODUCT --------------------------------------------
- // START OF Salary Loan PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Salary Loan'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Salary Loan</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Salary Loan'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Salary Loan'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Salary Loan'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Salary Loan'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF Salary Loan PRODUCT --------------------------------------------
- // START OF REF PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'REF'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>REF</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'REF'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'REF'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'REF'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'REF'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF REF PRODUCT --------------------------------------------
- // START OF Corpbank PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Corpbank</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF CorpbankPRODUCT --------------------------------------------
- // START OF Combank PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Combank</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF Combank PRODUCT --------------------------------------------
- // START OF Other Product PRODUCT --------------------------------------------
- // Auto - Encoding
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Other Product'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td>Other Product</td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto-Encoding
- // Auto FM
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Other Product'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Auto FM
- // Tele CI
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Other Product'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI
- // Field CI - Metro
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Other Product'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro
- // Field CI - Provincial
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Other Product'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td></tr>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial
- // End OF Other Product PRODUCT --------------------------------------------
- // Start of Total ------------------------------------------
- // Encoding - Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Encoding'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<tr><td><b>Total</b></td> <td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Encoding - Total
- // File Matching - Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'File Matching'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of File Matching - Total
- // Tele CI - Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Tele CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Tele CI - Total
- // Field CI - Metro - Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Metro - Total
- // Field CI - Provincial - Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Field CI'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Field CI - Provincial - Total
- // End of Total ------------------------------------------
- echo "</table>";
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement