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='volAp' 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> Real Estate </th>
- <th> TVR </th>
- <th> Auto Appraisal </th>
- </tr>";
- // START OF Mortgage PRODUCT --------------------------------------------
- // Mortgage - Real Estate
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'Appraisal - Real Estate'")) {
- /* 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 Mortgage - Real Estate
- // Mortgage - TVR
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Mortgage'
- AND `rec_proc` = 'Appraisal - TVR'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Mortgage TVR
- echo "<td> - </td></tr>";
- // End OF Mortgage PRODUCT --------------------------------------------
- // START OF SME PRODUCT --------------------------------------------
- // Mortgage - Real Estate
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'Appraisal - Real Estate'")) {
- /* 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 Mortgage - Real Estate
- // Mortgage - TVR
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'SME'
- AND `rec_proc` = 'Appraisal - TVR'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Mortgage TVR
- echo "<td> - </td></tr>";
- // End OF SME PRODUCT --------------------------------------------
- // START OF Corpbank PRODUCT --------------------------------------------
- // Mortgage - Real Estate
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'Appraisal - Real Estate'")) {
- /* 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 Mortgage - Real Estate
- // Mortgage - TVR
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Corpbank'
- AND `rec_proc` = 'Appraisal - TVR'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Mortgage TVR
- echo "<td> - </td></tr>";
- // End OF Corpbank PRODUCT --------------------------------------------
- // START OF Combank PRODUCT --------------------------------------------
- // Mortgage - Real Estate
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'Appraisal - Real Estate'")) {
- /* 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 Mortgage - Real Estate
- // Mortgage - TVR
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'Combank'
- AND `rec_proc` = 'Appraisal - TVR'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td>%d</td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Mortgage TVR
- echo "<td> - </td></tr>";
- // End OF Combank PRODUCT --------------------------------------------
- // START OF CCD PRODUCT --------------------------------------------
- echo "<tr><td>CCD</td> <td> - </td>";
- echo "<td> - </td>";
- // CCD - Auto
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'CCD'
- AND `rec_proc` = 'Appraisal - Auto'")) {
- /* 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 CCD - Auto
- // End OF CCD PRODUCT --------------------------------------------
- // START OF WAF PRODUCT --------------------------------------------
- echo "<tr><td>WAF</td> <td> - </td>";
- echo "<td> - </td>";
- // WAF - Auto
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'WAF'
- AND `rec_proc` = 'Appraisal - Auto'")) {
- /* 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 WAF - Auto
- // End OF WAF PRODUCT --------------------------------------------
- // START OF PhilMay PRODUCT --------------------------------------------
- echo "<tr><td>PhilMay</td> <td> - </td>";
- echo "<td> - </td>";
- // CCD - Auto
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_prod` = 'PhilMay'
- AND `rec_proc` = 'Appraisal - Auto'")) {
- /* 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 PhilMay - Auto
- // End OF PhilMay PRODUCT --------------------------------------------
- // Start of Total --------------------------------------------
- // Real Estate Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Appraisal - Real Estate'")) {
- /* 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 Real Estate Total
- // Appraisal - TVR Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Appraisal - TVR'")) {
- /* determine number of rows result set */
- $row_cnt = $result->num_rows;
- printf("<td> %d </td>", $row_cnt);
- /* close result set */
- $result->close();
- }
- // end of Appraisal - TVR Total
- // Appraisal - Auto Total
- if ($result = $con->query("
- SELECT `recID`
- FROM `samprec`
- WHERE `recDate` = '".inputDate()."'
- AND `rec_proc` = 'Appraisal - Auto'")) {
- /* 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 Appraisal - Auto Total
- // End of Total --------------------------------------------
- echo "</table>";
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement