/var/www/doncode.com.ua/www/libs

Name	Size	Mode	Actions
class.ajax.php	794	0644	edit dl rm
class.Barcode.php	45936	0644	edit dl rm
class.BarcodeEAN.php	2432	0644	edit dl rm
class.BarcodeI25.php	2171	0644	edit dl rm
class.barcode_code_39.php	3361	0644	edit dl rm
class.bootstrap.php	14340	0644	edit dl rm
class.command.php	568	0644	edit dl rm
class.controller.php	1116	0644	edit dl rm
class.cron.php	844	0644	edit dl rm
class.database.php	2065	0644	edit dl rm
class.dcu_api.php	2805	0644	edit dl rm
class.form.php	2910	0644	edit dl rm
class.gd.php	8975	0644	edit dl rm
class.hash.php	210	0644	edit dl rm
class.mail.php	5213	0644	edit dl rm
class.model.php	3945	0644	edit dl rm
class.num_to_string.php	4016	0644	edit dl rm
class.order.php	4630	0644	edit dl rm
class.payment.php	1380	0644	edit dl rm
class.session.php	1178	0644	edit dl rm
class.transfer_scales.php	10626	0644	edit dl rm
class.validate.php	2614	0644	edit dl rm
class.view.php	1562	0644	edit dl rm

Edit: /var/www/doncode.com.ua/www/libs/class.order.php (4630B)

<?php
class order
{
    function __construct()
    {
        $this->database = new database(DB_TYPE,DB_HOST,DB_NAME,DB_USER,DB_PASS,ENCODE);
	$this->mail	= new mail();
        $this->count    = 0;
        $this->def_order= array(
            'id'            => 0,
            'ontime'        => 0,
            'createdate'    => '',
            'ontimedate'    => '',
            'ontimetime'    => ''
        );
        $this->def_json= array(
            'fio'           => '',
            'phone'         => '',
            'adres'         => '',
            'house'         => '',
            'porch'         => '',
            'object'        => 0,
            'comment'       => '',
            'thecity'       => 0,
            'addcost'       => 0,
            'cost'          => 0,
            'options'       => array(),
            'adresX'        => array(array(
                'adres'     => '',
                'house'     => '',
                'object'    => 0
            ))
        );
    }

final public function cities($where=''){
        try{
            $sth  = $this->database->prepare("SELECT do.city_id,co.country_name_ru as country,r.region_name_ru as region,c.city_name_ru as city
		FROM `".DB_PREFIX."orders` do
		INNER JOIN city_ c ON c.`id_city` = do.`city_id`
		INNER JOIN region_ r ON r.`id_region` = c.`id_region`
		INNER JOIN country_ co ON co.`id_country` = c.`id_country`
		WHERE ".$where." GROUP BY do.`city_id`");
            $sth->execute();
	    $data = $sth->fetchAll(PDO::FETCH_ASSOC);
        }catch(PDOException $e){
            return $e->getMessage();            
        }
	//var_export($data);exit;
        return $data;
    }

final public function count ($where=''){
        $sql = "SELECT count(do.id)
                FROM `".DB_PREFIX."orders` AS do
                WHERE ".$where;
        $sth= $this->database->prepare($sql);
        $sth->execute();
        if ($sth->rowCount() > 0) {
            $row = $sth->fetch();
            return $row['count(do.id)'];
        }
        return 0;
    }
    
    final public function select ($where=''){
        $sql = "SELECT do.*, doa.json, so.name as status_name, so.color as status_color, so.id as status_code,
		c.city_name_ru as city, r.region_name_ru as region, co.country_name_ru as country, co.currency
                FROM `".DB_PREFIX."orders` AS do
                INNER JOIN `".DB_PREFIX."orders_adres` AS doa ON(do.id=doa.order_id)
                INNER JOIN `".DB_PREFIX."status_order` AS so ON(do.status_id=so.id)
                LEFT JOIN `city_` AS c ON(c.id_city=do.city_id)
                LEFT JOIN `region_` AS r ON(c.id_region=r.id_region)
                LEFT JOIN `country_` AS co ON(c.id_country=co.id_country)
                WHERE ".$where;
        $sth= $this->database->prepare($sql);
        $sth->execute();
        if ($sth->rowCount() > 0) {
            $this->setCount($sth->rowCount());
            while($row = $sth->fetch(PDO::FETCH_ASSOC)){
                $order = $this->def_order;
                $json = $this->def_json;
                if(isset($row['json'])){$row_json = json_decode($row['json'],true);}
                $row['json'] = array_merge($json,$row_json);
                $result[] = array_merge($order,$row);
            }
        }else{
            $order = $this->def_order;
            $order['json'] = $this->def_json;
            $result[] = $order;
        }

return $result;
    }
    
    final public function select_one ($where=''){
        $res = $this->select($where);
        return $res[0];
    }
    
    final public function cancel ($order_id,$status_id){
        $count = $this->database->update(DB_PREFIX.'orders',array(
                    'status'	    =>'cancel',
                    'status_id'     => $status_id,
                    'complitedate'  => date("Y-m-d H:i:s")
                    ),"id={$order_id} AND status!='cancel' AND status!='complite'");
        if($count>0){
	    $result['cmd'] = 'cancel_order';
	    $result['order_id'] = $order_id;
	    command::send(json_encode($result));
            return true;
            $message = '<html><body><h1>Привет админ</h1><br>
	    У тебя '.$c.' новых заказов<br><br>
	    Вход <a href="http://doncode.com.ua/">нажми здесь</a>
	    </body></html>';
	    //$this->mail->send('g0502212339@gmail.com', "Крон", $message);
        }else{
            return false;
        }
    }
    
    private function setCount($count){
        $this->count = $count;
    }
    
    final public function getCount(){
        return $this->count;
    }
}

database = new database(DB_TYPE,DB_HOST,DB_NAME,DB_USER,DB_PASS,ENCODE); $this->mail = new mail(); $this->count = 0; $this->def_order= array( 'id' => 0, 'ontime' => 0, 'createdate' => '', 'ontimedate' => '', 'ontimetime' => '' ); $this->def_json= array( 'fio' => '', 'phone' => '', 'adres' => '', 'house' => '', 'porch' => '', 'object' => 0, 'comment' => '', 'thecity' => 0, 'addcost' => 0, 'cost' => 0, 'options' => array(), 'adresX' => array(array( 'adres' => '', 'house' => '', 'object' => 0 )) ); } final public function cities($where=''){ try{ $sth = $this->database->prepare("SELECT do.city_id,co.country_name_ru as country,r.region_name_ru as region,c.city_name_ru as city FROM `".DB_PREFIX."orders` do INNER JOIN city_ c ON c.`id_city` = do.`city_id` INNER JOIN region_ r ON r.`id_region` = c.`id_region` INNER JOIN country_ co ON co.`id_country` = c.`id_country` WHERE ".$where." GROUP BY do.`city_id`"); $sth->execute(); $data = $sth->fetchAll(PDO::FETCH_ASSOC); }catch(PDOException $e){ return $e->getMessage(); } //var_export($data);exit; return $data; } final public function count ($where=''){ $sql = "SELECT count(do.id) FROM `".DB_PREFIX."orders` AS do WHERE ".$where; $sth= $this->database->prepare($sql); $sth->execute(); if ($sth->rowCount() > 0) { $row = $sth->fetch(); return $row['count(do.id)']; } return 0; } final public function select ($where=''){ $sql = "SELECT do.*, doa.json, so.name as status_name, so.color as status_color, so.id as status_code, c.city_name_ru as city, r.region_name_ru as region, co.country_name_ru as country, co.currency FROM `".DB_PREFIX."orders` AS do INNER JOIN `".DB_PREFIX."orders_adres` AS doa ON(do.id=doa.order_id) INNER JOIN `".DB_PREFIX."status_order` AS so ON(do.status_id=so.id) LEFT JOIN `city_` AS c ON(c.id_city=do.city_id) LEFT JOIN `region_` AS r ON(c.id_region=r.id_region) LEFT JOIN `country_` AS co ON(c.id_country=co.id_country) WHERE ".$where; $sth= $this->database->prepare($sql); $sth->execute(); if ($sth->rowCount() > 0) { $this->setCount($sth->rowCount()); while($row = $sth->fetch(PDO::FETCH_ASSOC)){ $order = $this->def_order; $json = $this->def_json; if(isset($row['json'])){$row_json = json_decode($row['json'],true);} $row['json'] = array_merge($json,$row_json); $result[] = array_merge($order,$row); } }else{ $order = $this->def_order; $order['json'] = $this->def_json; $result[] = $order; } return $result; } final public function select_one ($where=''){ $res = $this->select($where); return $res[0]; } final public function cancel ($order_id,$status_id){ $count = $this->database->update(DB_PREFIX.'orders',array( 'status' =>'cancel', 'status_id' => $status_id, 'complitedate' => date("Y-m-d H:i:s") ),"id={$order_id} AND status!='cancel' AND status!='complite'"); if($count>0){ $result['cmd'] = 'cancel_order'; $result['order_id'] = $order_id; command::send(json_encode($result)); return true; $message = '

Привет админ

У тебя '.$c.' новых заказов

Вход нажми здесь '; //$this->mail->send('g0502212339@gmail.com', "Крон", $message); }else{ return false; } } private function setCount($count){ $this->count = $count; } final public function getCount(){ return $this->count; } }