erp/core/CoreApp/controllers/Goodimglibrary.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Goodimglibrary extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->load->library('session');
        $this->load->_model('Model_goodimgs','goodimgs');
        $this->load->_model('Model_goods','goods');
    }
	private $show_url = "https://lyerposs.wepolicy.cn";	
    public function _remap($arg,$arg_array)
    {
		if($arg=="detail"){
			//$this->_detial($arg_array);
		}elseif($arg=="edit"){
			$this->_editData($arg_array);
		}else{
			$this->_index();
		}
	}
	private function _index(){
		if($this->input->method() == 'post'){
            $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$title = $this->input->post('title',true);
            $zh= $this->input->post('zh',true);
            $sku = $this->input->post('sku',true);
            $category = $this->input->post('category',true);
            $category = trim($category);
            $grade = $this->input->post('grade',true);
            $grade = trim($grade);
            $color = $this->input->post('color',true);
            $color = trim($color);
            $lowe = $this->input->post('lowe',true);
            $lowe =  trim($lowe);
            $lacetype = $this->input->post('lacetype',true);
            $lacetype =  trim($lacetype);
            $lacecolor = $this->input->post('lacecolor',true);
            $lacecolor =  trim($lacecolor);
            $size = $this->input->post('size',true);
            $size = trim($size);
            $density = $this->input->post('density',true);
            $density = trim($density);
            $haircap = $this->input->post('haircap',true);
            $haircap = trim($haircap);
            $hairnumber = $this->input->post('hairnumber',true);
            $hairnumber = trim($hairnumber);
          
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }

            $this->db->select('g.id, g.features, g.title, g.sku, g.zh, g.jm,g.has_source,g.update_time, gi.id as img_id, gi.source_cont');
            $this->db->from('crowd_goods as g');
            $this->db->join('crowd_goodimgs as gi', 'g.id = gi.goods_id', 'left');
            if($title){
                $title = trim($title);
                $this->db->like('g.title', $title);
            }
            if($zh){
                $zh = trim($zh);
                $this->db->like('g.zh', $zh);
            }
            if($sku){
                $sku = trim($sku);
                $this->db->like('g.sku', $sku);
            }
            if($category){
                $category = trim($category);
                $this->db->like('g.features', $category);
            }
            if($grade){
                $grade = trim($grade);
                $this->db->like('g.features', $grade);
            }
            if($color){
                $color = trim($color);
                $this->db->like('g.features', $color);
            }
            if($lowe){
                $lowe = trim($lowe);
                $this->db->like('g.features', $lowe);
            }
            if($lacetype){
                $lacetype = trim($lacetype);
                $this->db->like('g.features', $lacetype);
            }
            if($lacecolor){
                $lacecolor = trim($lacecolor);
                $this->db->like('g.features', $lacecolor);
            }
            if($size){
                $size = trim($size);
                $this->db->like('g.features', $size);
            }
            if($density){
                $density = trim($density);
                $this->db->like('g.features', $density);
            }
            if($haircap){
                $haircap = trim($haircap);
                $this->db->like('g.features', $haircap);
            }
            if($hairnumber){
                $hairnumber = trim($hairnumber);
                $this->db->like('g.features', $hairnumber);
            }
            $this->db->order_by('g.has_source', 'desc');
            $this->db->order_by('g.update_time', 'desc');
            $this->db->order_by('g.id', 'asc');
            
            

            // 分页 (limit, offset)
            $this->db->limit($perpage, $start);
    
            $query = $this->db->get();

            $list =  $query->result_array();
            $info_list = [];
            foreach($list as $k => $v){
                $info_list[$k]['id'] = $v['id'];
                $info_list[$k]['sku'] = $v['sku'];
                $info_list[$k]['title'] = $v['title'];
                $info_list[$k]['zh'] = $v['zh'];
                $info_list[$k]['update_time'] = empty($v['update_time'])? '' : date('Y-m-d H:i',$v['update_time']);
                $info_list[$k]['imgs'] = $this->transimg($v['source_cont']);
            }
			$this->db->from('crowd_goods');
            if($title){
                $title = trim($title);
                $this->db->like('title', $title);
            }
            if($zh){
                $zh = trim($zh);
                $this->db->like('zh', $zh);
            }
            if($sku){
                $sku = trim($sku);
                $this->db->like('sku', $sku);
            }
            if($category){
                $category = trim($category);
                $this->db->like('features', $category);
            }
            if($grade){
                $grade = trim($grade);
                $this->db->like('features', $grade);
            }
            if($color){
                $color = trim($color);
                $this->db->like('features', $color);
            }
            if($lowe){
                $lowe = trim($lowe);
                $this->db->like('features', $lowe);
            }
            if($lacetype){
                $lacetype = trim($lacetype);
                $this->db->like('features', $lacetype);
            }
            if($lacecolor){
                $lacecolor = trim($lacecolor);
                $this->db->like('features', $lacecolor);
            }
            if($size){
                $size = trim($size);
                $this->db->like('features', $size);
            }
            if($density){
                $density = trim($density);
                $this->db->like('features', $density);
            }
            if($haircap){
                $haircap = trim($haircap);
                $this->db->like('features', $haircap);
            }
            if($hairnumber){
                $hairnumber = trim($hairnumber);
                $this->db->like('features', $hairnumber);
            }

            $total = $this->db->count_all_results();
			
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
        }else{
            $this->_Template('goodimglibrary',$this->data);
        }
	}

    private function transimg($source_cont){
        $str = ' ';
        if(!empty($source_cont)){
            $imgs = json_decode($source_cont,true);
          
            foreach($imgs as $k => $v){
                $type = $this->_checkVideo($v);
                $url = $this->_transingurl($v);
                if($type == "video"){
                    $str.= '<video controls="true" width="100" src="'.$url.'" alt="video image" style="margin-right:3px;"></video>';
                }else{
                    $str .= '<img width="100px" src="'.$url.'" alt="image" style="margin-right:3px;" onclick="showBigImg(this)">';
                }
            }
           
        }
       return$str;
    }
	private function _editData($arg_array){
        if($this->input->method() == 'post'){
            $id = $this->input->post('id',true);
            $img = $this->input->post('img',true);
            if(empty($img)){
                $img = [];
            }
            foreach($img as $k => $v){
                $img[$k] = str_replace($this->show_url, '', $v);
            }
            $info  =  $this->db->get_where('crowd_goods',array('id'=>$id))->row_array();    
            $images = $this->goodimgs->find("goods_id = ".$id);
            $has_source = empty($img)?0:5;
            $update_time = time();
            if(empty($images)){
                if($this->goodimgs->insert(array('goods_id'=>$id,'features'=>$info['features'],'source_cont'=>json_encode($img,JSON_UNESCAPED_SLASHES)))){
                    $this->goods->save(array('has_source'=>$has_source,'update_time'=>$update_time),$id);
                    echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
                }else{
                    echo json_encode(array('msg'=>'修改失败，请重试1','success'=>false));exit;
                }

            }else{
                if($this->goodimgs->save(array('features'=>$info['features'],'source_cont'=>json_encode($img,JSON_UNESCAPED_SLASHES)),$images['id'])){
                    $this->goods->save(array('has_source'=>$has_source,'update_time'=>$update_time),$id);
                    echo json_encode(array('msg'=>'修改成功','success'=>true));exit;
                }else{
                    echo json_encode(array('msg'=>'修改失败，请重试2','success'=>false));exit;
                }
            }

        }
        if($this->input->method() == 'get'){
            $id = $arg_array[0];
            $goods = $this->db->get_where('crowd_goods',array('id'=>$id))->row_array();
            $this->db->where('goods_id',$id);
            $images = $this->db->get('crowd_goodimgs')->result_array();
            if(empty($images)){
                $goods['images'] = [];
            }else{
                $imgs = json_decode($images[0]['source_cont'],true);
                $final_imgs = [];
                foreach($imgs as $k => $v){
                    $final_imgs[$k]['url'] = $this->_transingurl($v);
                    $final_imgs[$k]['type'] = $this->_checkVideo($v);
                }
                $goods['images'] = $final_imgs;
            }
           
           
            $this->data['goods'] = $goods;
            $this->_Template('goodimglibrary_edit',$this->data);
            
        }
    }
    //根据后缀判断是否是视频
    private function _checkVideo($str){
        $hz_arr = explode(".",$str);
        $hz = end($hz_arr);
        if(in_array($hz,['mp4','flv','rmvb','avi','wmv','mov','rm','mkv'])){
            return "video";
        }
        return "img";

    }


    private function _transingurl($url){
        $url_arr = explode('/', $url);
		$filename = array_pop($url_arr);
		$filename = rawurlencode($filename);
		$url_arr[] = $filename;
		$final_url = implode('/', $url_arr);
        $final_url = $this->show_url.$final_url;
		return $final_url;
    }
	
}