FM / models

/var/www/doncode.com.ua/www/models/

/var/www/doncode.com.ua/www/models

Name	Size	Mode	Actions
class.admin_model.php	37702	0644	edit dl rm
class.api_model.php	32864	0644	edit dl rm
class.archive_model.php	2975	0644	edit dl rm
class.arm_model.php	9393	0644	edit dl rm
class.dcccatalog_model.php	9871	0644	edit dl rm
class.dcclist_model.php	10829	0644	edit dl rm
class.dccsupport_model.php	471	0644	edit dl rm
class.dccupdate_model.php	470	0644	edit dl rm
class.dmp_platforms_model.php	7959	0644	edit dl rm
class.docs_model.php	1128	0644	edit dl rm
class.doncode_users_model.php	6712	0644	edit dl rm
class.driver_model.php	369	0644	edit dl rm
class.exchange_model.php	8266	0644	edit dl rm
class.files_model.php	194	0644	edit dl rm
class.index_model.php	1129	0644	edit dl rm
class.login_model.php	25014	0644	edit dl rm
class.mobile_users_model.php	10009	0644	edit dl rm
class.news_model.php	7721	0644	edit dl rm
class.orders_model.php	9782	0644	edit dl rm
class.settings_model.php	11799	0644	edit dl rm
class.support_model.php	28783	0644	edit dl rm
class.users_model.php	9154	0644	edit dl rm
class.user_model.php	44873	0644	edit dl rm

Edit: /var/www/doncode.com.ua/www/models/class.dcccatalog_model.php (9871B)

<?php
/**
 * @author Calipsod
 * @copyright Doncode
 * @package Warhouse 
 */
class dcccatalog_model extends model {
    public function __construct(){
        parent::__construct();
    }
    public function fetchCountRecords(){
        $sth = $this->database->prepare("SELECT count(*) as `count`  FROM `city_` c INNER JOIN `region_` r ON c.`id_region`=r.`id_region` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `catalog`=1");
        $sth->execute();
        return $sth->fetch ();
    }
    public function catalogGetList ($page=0,$country=0,$region=0,$city=0){
		if ($country == 0) {
			$selector = "страну";
			//ajax::fail( 'нет DCC, а это очень грутсно :(' );
					 return false;
		} elseif ($region == 0) {
			$selector = "область";
			//ajax::fail( 'нет DCC, а это очень грутсно :(' );
					 return false;
		} elseif ($city == 0) {
			$selector = "город";
			//ajax::fail( 'нет DCC, а это очень грутсно :(' );
					 return false;
		} else {
			if ($page!=0){
				$page_number=abs(($page-1)*LIMIT);
			}else{
				$page_number=0;
			}
			try{
				$sth=$this->database->prepare("SELECT c.`id_city`, c.`city_name_ru`, r.`region_name_ru`, co.`country_name_ru`  FROM `city_` c INNER JOIN `region_` r ON c.`id_region`=r.`id_region` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `catalog`=1 LIMIT  $page_number , ".LIMIT." ");
				$sth->execute();
			}catch(PDOException $e){
				ajax::fail($e->getMessage());
				return false;
			}
			$max_sum_call = 0;
			if($sth->rowCount()>0){
					 $arr=   $sth->fetchAll();
					 echo json_encode($arr);
			}else{
				if($page_number==0){
					 ajax::fail( 'нет DCC, а это очень грутсно :(' );
					 return false;
				}
			   $page_number-=1;
			   $this->catalogGetList($page_number);
			}
		}
    }
    public function getTaxiById ($id,$ajax=true){
        $sth=$this->database->prepare("SELECT *  FROM `catalog_taxi`  WHERE `deleted`='0' AND `id`=:id");
        $sth->execute(array(':id'=>$id));
        if ($ajax){
            echo json_encode($sth->fetch());
        }else{
            return $sth->fetchAll();
        }
    }
    public function getDCC ($ajax=false){ // Города добавленные в каталог
        $sth=$this->database->prepare("SELECT d.`gid` as id, c.`city_name_ru`, co.`country_name_ru`,d.`taxi_name`  FROM `dcc` d INNER JOIN `city_` c ON c.`id_city`=d.`city_id` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `deleted`=0");
        $sth->execute();
        if ($ajax){
            echo json_encode($sth->fetch());
        }else{
            return $sth->fetchAll();
        }
    }
    public function getRegions ($ajax=false){ // Города добавленные в каталог
        $sth=$this->database->prepare("SELECT c.`id_city`, c.`city_name_ru`, r.`region_name_ru`, co.`country_name_ru`  FROM `city_` c INNER JOIN `region_` r ON c.`id_region`=r.`id_region` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `catalog`=1");
        $sth->execute();
        if ($ajax){
            echo json_encode($sth->fetch());
        }else{
            return $sth->fetchAll();
        }
    }
    public function getCountry ($ajax=false){
        $sth=$this->database->prepare("SELECT `id_country` as id,`country_name_ru` as name  FROM `country_`");
        $sth->execute();
        if ($ajax){
            echo json_encode($sth->fetch());
        }else{
            return $sth->fetchAll();
        }
    }
    public function getRegion ($id_country=0,$ajax=false){
        $sth=$this->database->prepare("SELECT `id_region` as id,`region_name_ru` as name  FROM `region_` WHERE id_country = ".$id_country);
        $sth->execute();
        if ($ajax){
            echo json_encode($sth->fetch());
        }else{
            return $sth->fetchAll();
        }
    }
    public function getCity ($id_region=0,$ajax=false){
        $sth=$this->database->prepare("SELECT `id_city` as id,`city_name_ru` as name  FROM `city_` WHERE `catalog`=0 AND `id_region` = ".$id_region);
        $sth->execute();
        if ($ajax){
            echo json_encode($sth->fetch());
        }else{
            return $sth->fetchAll();
        }
    }
    public function addCity ($id_city,$ajax=false){
        $sth=$this->database->prepare("UPDATE `city_` SET catalog=1 WHERE `id_city` = ".$id_city);
        $sth->execute();
		return true;
	}    
	public function delCity ($id_city,$ajax=false){
        $sth=$this->database->prepare("UPDATE `city_` SET catalog=0 WHERE `id_city` = ".$id_city);
        $sth->execute();
		return true;
	}
    public function delTaxi($id){
            $sth=$this->database->prepare("UPDATE `catalog_taxi` SET `deleted`='1' WHERE `id`=$id ;");
            $sth->execute();
        if ($sth->rowCount()>0){
            ajax::success('Служба удалена id='.$id);
            $this->database->log('Служба удалена id='.$id);
        }else{
            ajax::fail('Не удалось удалить службу id='.$id);
            $this->database->log('Не удалось удалить службу id='.$id);
        }
    }
    public function saveTaxi(){
            try{
            $this->form->post('name','Название Такси')->val('emptyStr')
                       ->post('director_name')
                       ->post('director_phone')
                       ->post('dcc')
					   ->post('id')
                       ->post('vip')
                       ->post('show')
                       ->post('id_city')
                       ->post('description')
						->post('p1')
                       ->post('p2')
                       ->post('p3')
                       ->post('p4')
                       ->post('p5')
                       ->post('p6')
                       ->post('p7')
                       ->post('p8')
                       ->post('p9')
                       ->post('p10');
            $this->form->submit();
            $data = $this->form->fetch(); 
           }catch(Exception $e){
            ajax::fail($e->getMessage());
            $this->database->log('Не удалось обновить данные службы '.$e->getMessage() );
            return false;
           }
           try{
            $id=$data['id'];
            unset($data['id']);
            $this->database->update('catalog_taxi',$data,'id='.$id);
           }catch(PDOException $e){
                ajax::fail($e->getMessage());
                $this->database->log('Не удалось обновить данные службы '.$e->getMessage() );
                return false;
           }
           ajax::success("Данные службы ".$data['name']." обновлены.");
           $this->database->log("Данные службы ".$data['name']." обновлены."  );
    }
    public function createTaxi(){
           try{
            $this->form->post('name','Название Такси')->val('emptyStr')
						->post('director_name')
						->post('director_phone')
						->post('dcc')
						->post('vip')
						->post('show')
						->post('id_city')
						->post('description')
						->post('p1')
						->post('p2')
						->post('p3')
						->post('p4')
						->post('p5')
						->post('p6')
						->post('p7')
						->post('p8')
						->post('p9')
						->post('p10');
            $this->form->submit();
            $data = $this->form->fetch();
           }catch(Exception $e){
            if(ajax::check_ajax_request()){
                ajax::fail($e->getMessage());
            }else{
                session::set('msgFail',$e->getMessage());
                $this->database->log('Не удалось создать службу '.$e->getMessage() );
                header("Location:".$_SERVER["HTTP_REFERER"]);
            }
            exit;
           }
           try{
            $this->database->insert('catalog_taxi',$data);
            }catch(PDOException $e){
                session::set('msgFail',$e->getMessage());
                $this->database->log('Не удалось создать службу - '.$data['name']);
                header("Location:".$_SERVER["HTTP_REFERER"]);
                exit;                     
           }  
           if(ajax::check_ajax_request()){
            ajax::success("Создана служба ".$data['name']);
           }else{
                session::set('msgSuccess',"Создана служба ".$data['name']);
                $this->database->log('Создана служба '.$data['name']);
                header("Location:".URL."dcccatalog");
           }   
                exit;               
    }
    public function search ($ch,$type){
        try{
          $char = $this->database->quote('%'.$ch.'%');
          $sth = $this->database->prepare("SELECT `id`,`FIO` FROM `contractor` WHERE `$type` LIKE $char AND `deleted`='0' LIMIT ".LIMIT);
          $sth->execute( );
          ajax::out($sth->fetchAll());
        }  catch (Exception $e){
            ajax::fail($e->getMessage());
            return false;
        }
    }
    public function fetechContractor ($id){
        try{
            $sth = $this->database->prepare("SELECT c.*,t.name as tName  FROM `contractor` c INNER JOIN `type_contractor` t ON (c.type=t.id)  WHERE c.deleted='0' AND c.id=:id  LIMIT  1 ");
            $sth->execute(array(':id'=>$id));
            ajax::out($sth->fetchAll());
                    return;
        }catch(PDOException $e){
            ajax::fail($e->getMessage());
            return ;
        }
    }
}

database->prepare("SELECT count(*) as `count` FROM `city_` c INNER JOIN `region_` r ON c.`id_region`=r.`id_region` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `catalog`=1"); $sth->execute(); return $sth->fetch (); } public function catalogGetList ($page=0,$country=0,$region=0,$city=0){ if ($country == 0) { $selector = "страну"; //ajax::fail( 'нет DCC, а это очень грутсно :(' ); return false; } elseif ($region == 0) { $selector = "область"; //ajax::fail( 'нет DCC, а это очень грутсно :(' ); return false; } elseif ($city == 0) { $selector = "город"; //ajax::fail( 'нет DCC, а это очень грутсно :(' ); return false; } else { if ($page!=0){ $page_number=abs(($page-1)*LIMIT); }else{ $page_number=0; } try{ $sth=$this->database->prepare("SELECT c.`id_city`, c.`city_name_ru`, r.`region_name_ru`, co.`country_name_ru` FROM `city_` c INNER JOIN `region_` r ON c.`id_region`=r.`id_region` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `catalog`=1 LIMIT $page_number , ".LIMIT." "); $sth->execute(); }catch(PDOException $e){ ajax::fail($e->getMessage()); return false; } $max_sum_call = 0; if($sth->rowCount()>0){ $arr= $sth->fetchAll(); echo json_encode($arr); }else{ if($page_number==0){ ajax::fail( 'нет DCC, а это очень грутсно :(' ); return false; } $page_number-=1; $this->catalogGetList($page_number); } } } public function getTaxiById ($id,$ajax=true){ $sth=$this->database->prepare("SELECT * FROM `catalog_taxi` WHERE `deleted`='0' AND `id`=:id"); $sth->execute(array(':id'=>$id)); if ($ajax){ echo json_encode($sth->fetch()); }else{ return $sth->fetchAll(); } } public function getDCC ($ajax=false){ // Города добавленные в каталог $sth=$this->database->prepare("SELECT d.`gid` as id, c.`city_name_ru`, co.`country_name_ru`,d.`taxi_name` FROM `dcc` d INNER JOIN `city_` c ON c.`id_city`=d.`city_id` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `deleted`=0"); $sth->execute(); if ($ajax){ echo json_encode($sth->fetch()); }else{ return $sth->fetchAll(); } } public function getRegions ($ajax=false){ // Города добавленные в каталог $sth=$this->database->prepare("SELECT c.`id_city`, c.`city_name_ru`, r.`region_name_ru`, co.`country_name_ru` FROM `city_` c INNER JOIN `region_` r ON c.`id_region`=r.`id_region` INNER JOIN `country_` co ON c.`id_country`=co.`id_country` WHERE `catalog`=1"); $sth->execute(); if ($ajax){ echo json_encode($sth->fetch()); }else{ return $sth->fetchAll(); } } public function getCountry ($ajax=false){ $sth=$this->database->prepare("SELECT `id_country` as id,`country_name_ru` as name FROM `country_`"); $sth->execute(); if ($ajax){ echo json_encode($sth->fetch()); }else{ return $sth->fetchAll(); } } public function getRegion ($id_country=0,$ajax=false){ $sth=$this->database->prepare("SELECT `id_region` as id,`region_name_ru` as name FROM `region_` WHERE id_country = ".$id_country); $sth->execute(); if ($ajax){ echo json_encode($sth->fetch()); }else{ return $sth->fetchAll(); } } public function getCity ($id_region=0,$ajax=false){ $sth=$this->database->prepare("SELECT `id_city` as id,`city_name_ru` as name FROM `city_` WHERE `catalog`=0 AND `id_region` = ".$id_region); $sth->execute(); if ($ajax){ echo json_encode($sth->fetch()); }else{ return $sth->fetchAll(); } } public function addCity ($id_city,$ajax=false){ $sth=$this->database->prepare("UPDATE `city_` SET catalog=1 WHERE `id_city` = ".$id_city); $sth->execute(); return true; } public function delCity ($id_city,$ajax=false){ $sth=$this->database->prepare("UPDATE `city_` SET catalog=0 WHERE `id_city` = ".$id_city); $sth->execute(); return true; } public function delTaxi($id){ $sth=$this->database->prepare("UPDATE `catalog_taxi` SET `deleted`='1' WHERE `id`=$id ;"); $sth->execute(); if ($sth->rowCount()>0){ ajax::success('Служба удалена id='.$id); $this->database->log('Служба удалена id='.$id); }else{ ajax::fail('Не удалось удалить службу id='.$id); $this->database->log('Не удалось удалить службу id='.$id); } } public function saveTaxi(){ try{ $this->form->post('name','Название Такси')->val('emptyStr') ->post('director_name') ->post('director_phone') ->post('dcc') ->post('id') ->post('vip') ->post('show') ->post('id_city') ->post('description') ->post('p1') ->post('p2') ->post('p3') ->post('p4') ->post('p5') ->post('p6') ->post('p7') ->post('p8') ->post('p9') ->post('p10'); $this->form->submit(); $data = $this->form->fetch(); }catch(Exception $e){ ajax::fail($e->getMessage()); $this->database->log('Не удалось обновить данные службы '.$e->getMessage() ); return false; } try{ $id=$data['id']; unset($data['id']); $this->database->update('catalog_taxi',$data,'id='.$id); }catch(PDOException $e){ ajax::fail($e->getMessage()); $this->database->log('Не удалось обновить данные службы '.$e->getMessage() ); return false; } ajax::success("Данные службы ".$data['name']." обновлены."); $this->database->log("Данные службы ".$data['name']." обновлены." ); } public function createTaxi(){ try{ $this->form->post('name','Название Такси')->val('emptyStr') ->post('director_name') ->post('director_phone') ->post('dcc') ->post('vip') ->post('show') ->post('id_city') ->post('description') ->post('p1') ->post('p2') ->post('p3') ->post('p4') ->post('p5') ->post('p6') ->post('p7') ->post('p8') ->post('p9') ->post('p10'); $this->form->submit(); $data = $this->form->fetch(); }catch(Exception $e){ if(ajax::check_ajax_request()){ ajax::fail($e->getMessage()); }else{ session::set('msgFail',$e->getMessage()); $this->database->log('Не удалось создать службу '.$e->getMessage() ); header("Location:".$_SERVER["HTTP_REFERER"]); } exit; } try{ $this->database->insert('catalog_taxi',$data); }catch(PDOException $e){ session::set('msgFail',$e->getMessage()); $this->database->log('Не удалось создать службу - '.$data['name']); header("Location:".$_SERVER["HTTP_REFERER"]); exit; } if(ajax::check_ajax_request()){ ajax::success("Создана служба ".$data['name']); }else{ session::set('msgSuccess',"Создана служба ".$data['name']); $this->database->log('Создана служба '.$data['name']); header("Location:".URL."dcccatalog"); } exit; } public function search ($ch,$type){ try{ $char = $this->database->quote('%'.$ch.'%'); $sth = $this->database->prepare("SELECT `id`,`FIO` FROM `contractor` WHERE `$type` LIKE $char AND `deleted`='0' LIMIT ".LIMIT); $sth->execute( ); ajax::out($sth->fetchAll()); } catch (Exception $e){ ajax::fail($e->getMessage()); return false; } } public function fetechContractor ($id){ try{ $sth = $this->database->prepare("SELECT c.*,t.name as tName FROM `contractor` c INNER JOIN `type_contractor` t ON (c.type=t.id) WHERE c.deleted='0' AND c.id=:id LIMIT 1 "); $sth->execute(array(':id'=>$id)); ajax::out($sth->fetchAll()); return; }catch(PDOException $e){ ajax::fail($e->getMessage()); return ; } } }