Esempio n. 1
0
    {
        $db_connection = mysql_connect($this->db_server, $this->db_user, $this->db_password) or die(mysql_errno() . " - " . mysql_error() . "<br>");
        if (mysql_select_db($this->db_name)) {
            if (!($result = mysql_query("SELECT DISTINCT `cafe_id` FROM `cafeactivation`"))) {
                print __CLASS__ . "::" . __FUNCTION__ . "()[" . __FILE__ . ":" . __LINE__ . "]: " . mysql_errno() . " - " . mysql_error() . "<br>";
            }
        } else {
            print __CLASS__ . "::" . __FUNCTION__ . "()[" . __FILE__ . ":" . __LINE__ . "]: " . mysql_errno() . " - " . mysql_error() . "<br>";
        }
        //$row_count = mysql_num_rows($result);
        return $result;
        mysql_close($db_connection);
    }
}
//creating objects
$cafe_pay = new CafePay();
$cafe_details = new CafeDetails();
$result_cafe = $cafe_details->getAllActiveCafeIds();
while ($get_rows = mysql_fetch_array($result_cafe)) {
    $cafe_user_id = $get_rows['cafe_id'];
    $result = $cafe_details->getMacIdsByCafeUID($cafe_user_id);
    $amt = 0;
    while ($row = mysql_fetch_array($result)) {
        $mac_amt = 0;
        $mac_time = $cafe_pay->calcTimeOfMac($row['mac_id']);
        $mac_amt = $cafe_pay->calcAmountMac($cafe_user_id, $row['mac_id']);
        $amt = $amt + $mac_amt;
        $cafe_pay->insertPayMac($cafe_user_id, $row['mac_id'], $mac_time, $mac_amt);
    }
    $cafe_pay->insertPayCafe($cafe_user_id, $amt);
}
Esempio n. 2
0
<?php

include 'account/auth.php';
include "../templates/header.php";
//including classes
include '../classes/CafeDetails.php';
include '../classes/CafeTrac.php';
include '../classes/cafepayment.php';
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
//creating objects
$cafe_details = new CafeDetails();
$cafe_trac = new CafeTrac();
$cafe_pay = new CafePay();
//getting cafe id from session
$cafe_user_id = $_SESSION['SESS_MEMBER_ID'];
$cafe = $cafe_details->getAllDetailsOfCafeByCafeUID($cafe_user_id);
$cafe_name = mysql_fetch_array($cafe);
$day = date("d", mktime(0, 0, 0, date("m"), date("d"), date("Y")));
$rs_day = intval($day);
$i = 1;
$this_month_payment = 0;
?>

<body>
<div id="topPan"><div id="ImgPan"><img src="http://www.emmgts.com/images/logo.gif" title="Envisage Media" alt="Envisage Media " width="201" height="52" border="0" /></a></div>
<?php 
include "nav_bar.php";
?>
</div>
<div id="bodyPan">
<p>