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.archive_model.php (2975B)

<?php
/**
 * @author Calipsod
 * @copyright Doncode
 * @package Warhouse
 */
class archive_model extends model {
    
    public function __construct(){
        parent::__construct();   
    }
    public function out (){
         $this->database->log('Пользователь '.session::get('login').' вышел с системы.');
    }
    public function archiveList(){
		$filter = '';
		$performer_user_id = session::get('support_user_filter');
		if($performer_user_id>0){
			$filter.=' AND s.performer_user_id = '.$performer_user_id;
		}
		$status = session::get('support_status_filter');
		if($status>0){
			$filter.=' AND s.status = '.session::get('support_status_filter');
		}
			$sth = $this->database->prepare('SELECT s.id as sid, s.*,sw.*,cids.city_name_ru as gids, d.taxi_name,w.name as who FROM `support` s 
				LEFT OUTER JOIN `dcc` d ON d.gid=s.gid 
				LEFT OUTER JOIN `status_work` sw ON sw.wid=s.status 
				LEFT OUTER JOIN `who` w ON w.wid=s.who
				LEFT OUTER JOIN `city_` cids ON d.city_id=cids.id_city 
			WHERE s.deleted=1 '.$filter.'
			ORDER BY s.`create_date` DESC LIMIT 30');
			$sth->execute();
		if($sth->rowCount()>0){
		$arr =   $sth->fetchAll();				
			foreach($arr as $k => $value){
				$arr[$k]['create_date'] = bootstrap::HumanDatePrecise($arr[$k]['create_date']);
				$d_users = bootstrap::getDoncodeUsers ();
				if($arr[$k]['read_user_id']==0){
					$arr[$k]['read_user_id'] = 'новое';
				}else{
					$arr[$k]['read_user_id'] = $d_users[$arr[$k]['read_user_id']];
				}
				if($arr[$k]['who_perform_user_id']==0){
					$arr[$k]['who_perform_user_id'] = 'не назначен';
				}else{
					$arr[$k]['who_perform_user_id'] = $d_users[$arr[$k]['who_perform_user_id']];
				}
				if($arr[$k]['performer_user_id']==0){
					$arr[$k]['performer_user_id'] = 'нет исполнителя';
				}else{
					$arr[$k]['performer_user_id'] = $d_users[$arr[$k]['performer_user_id']];
				}
				
				if($arr[$k]['read_date']=='0000-00-00 00:00:00'){
					$arr[$k]['read_date'] = 'не обработана';
					$arr[$k]['read_'] = 'important';
				}else{
					$arr[$k]['read_date'] = bootstrap::HumanDatePrecise($arr[$k]['read_date']);
					$arr[$k]['read_'] = 'info';
				}
				if($arr[$k]['perform_date']=='0000-00-00 00:00:00'){
					$arr[$k]['perform_date'] = 'не назначена';
					$arr[$k]['perform_'] = 'important';
				}else{
					$arr[$k]['perform_date'] = bootstrap::HumanDatePrecise($arr[$k]['perform_date']);
					$arr[$k]['perform_'] = 'info';
				}
				if($arr[$k]['complite_date']=='0000-00-00 00:00:00'){
					$arr[$k]['complite_date'] = 'не выполнена';
					$arr[$k]['complite_'] = 'important';
				}else{
					$arr[$k]['complite_date'] = bootstrap::HumanDatePrecise($arr[$k]['complite_date']);
					$arr[$k]['complite_'] = 'success';
				}
			}
			echo json_encode($arr,true);
			return;
        }
        $page_number-=1;
        $this->archiveList($page_number);		
		return false;
    }
}

database->log('Пользователь '.session::get('login').' вышел с системы.'); } public function archiveList(){ $filter = ''; $performer_user_id = session::get('support_user_filter'); if($performer_user_id>0){ $filter.=' AND s.performer_user_id = '.$performer_user_id; } $status = session::get('support_status_filter'); if($status>0){ $filter.=' AND s.status = '.session::get('support_status_filter'); } $sth = $this->database->prepare('SELECT s.id as sid, s.*,sw.*,cids.city_name_ru as gids, d.taxi_name,w.name as who FROM `support` s LEFT OUTER JOIN `dcc` d ON d.gid=s.gid LEFT OUTER JOIN `status_work` sw ON sw.wid=s.status LEFT OUTER JOIN `who` w ON w.wid=s.who LEFT OUTER JOIN `city_` cids ON d.city_id=cids.id_city WHERE s.deleted=1 '.$filter.' ORDER BY s.`create_date` DESC LIMIT 30'); $sth->execute(); if($sth->rowCount()>0){ $arr = $sth->fetchAll(); foreach($arr as $k => $value){ $arr[$k]['create_date'] = bootstrap::HumanDatePrecise($arr[$k]['create_date']); $d_users = bootstrap::getDoncodeUsers (); if($arr[$k]['read_user_id']==0){ $arr[$k]['read_user_id'] = 'новое'; }else{ $arr[$k]['read_user_id'] = $d_users[$arr[$k]['read_user_id']]; } if($arr[$k]['who_perform_user_id']==0){ $arr[$k]['who_perform_user_id'] = 'не назначен'; }else{ $arr[$k]['who_perform_user_id'] = $d_users[$arr[$k]['who_perform_user_id']]; } if($arr[$k]['performer_user_id']==0){ $arr[$k]['performer_user_id'] = 'нет исполнителя'; }else{ $arr[$k]['performer_user_id'] = $d_users[$arr[$k]['performer_user_id']]; } if($arr[$k]['read_date']=='0000-00-00 00:00:00'){ $arr[$k]['read_date'] = 'не обработана'; $arr[$k]['read_'] = 'important'; }else{ $arr[$k]['read_date'] = bootstrap::HumanDatePrecise($arr[$k]['read_date']); $arr[$k]['read_'] = 'info'; } if($arr[$k]['perform_date']=='0000-00-00 00:00:00'){ $arr[$k]['perform_date'] = 'не назначена'; $arr[$k]['perform_'] = 'important'; }else{ $arr[$k]['perform_date'] = bootstrap::HumanDatePrecise($arr[$k]['perform_date']); $arr[$k]['perform_'] = 'info'; } if($arr[$k]['complite_date']=='0000-00-00 00:00:00'){ $arr[$k]['complite_date'] = 'не выполнена'; $arr[$k]['complite_'] = 'important'; }else{ $arr[$k]['complite_date'] = bootstrap::HumanDatePrecise($arr[$k]['complite_date']); $arr[$k]['complite_'] = 'success'; } } echo json_encode($arr,true); return; } $page_number-=1; $this->archiveList($page_number); return false; } }