| | <?php |
| | namespace app\admin\controller; |
| | use think\Db; |
| |
|
| | class Images extends Base |
| | { |
| | public function __construct() |
| | { |
| | parent::__construct(); |
| | |
| | } |
| |
|
| | public function data() |
| | { |
| |
|
| | } |
| |
|
| | public function opt() |
| | { |
| | $param = input(); |
| | $this->assign('tab',$param['tab']); |
| | return $this->fetch('admin@images/opt'); |
| | } |
| |
|
| | public function del() |
| | { |
| | $param = input(); |
| | $fname = $param['ids']; |
| | if(!empty($fname)){ |
| | foreach($fname as $a){ |
| | $a = str_replace('\\','/',$a); |
| |
|
| | if( (substr($a,0,8) != "./upload") || count( explode("./",$a) ) > 2) { |
| |
|
| | } |
| | else{ |
| | $a = mac_convert_encoding($a,"UTF-8","GB2312"); |
| | if(file_exists($a)){ @unlink($a); } |
| | } |
| | } |
| | } |
| | return $this->success(lang('del_ok')); |
| | } |
| |
|
| | public function sync() |
| | { |
| | $param = input(); |
| |
|
| | $param['page'] = intval($param['page']) < 1 ? 1 : $param['page']; |
| | $param['limit'] = intval($param['limit']) < 1 ? 10 : $param['limit']; |
| | $flag = "#err". date('Y-m-d',time()); |
| |
|
| | if($param['tab']=='vod'){ |
| | $tab='vod'; |
| | $col_id ='vod_id'; |
| | $col_name ='vod_name'; |
| | $col_pic= $param['col']==2 ? 'vod_content' : 'vod_pic'; |
| | $col_time='vod_time'; |
| |
|
| | } |
| | elseif($param['tab']=='art'){ |
| | $tab='art'; |
| | $col_id ='art_id'; |
| | $col_name ='art_name'; |
| | $col_pic= $param['col']==2 ? 'art_content' :'art_pic'; |
| | $col_time='art_time'; |
| | } |
| | elseif($param['tab']=='topic'){ |
| | $tab='topic'; |
| | $col_id ='topic_id'; |
| | $col_name ='topic_name'; |
| | $col_pic=$param['col']==2 ? 'topic_content' :'topic_pic'; |
| | $col_time='topic_time'; |
| | } |
| | elseif($param['tab']=='actor'){ |
| | $tab='actor'; |
| | $col_id ='actor_id'; |
| | $col_name ='actor_name'; |
| | $col_pic=$param['col']==2 ? 'actor_content' :'actor_pic'; |
| | $col_time='actor_time'; |
| | } |
| | elseif($param['tab']=='role'){ |
| | $tab='role'; |
| | $col_id ='role_id'; |
| | $col_name ='role_name'; |
| | $col_pic=$param['col']==2 ? 'role_content' :'role_pic'; |
| | $col_time='role_time'; |
| | } |
| | elseif($param['tab']=='website'){ |
| | $tab='website'; |
| | $col_id ='website_id'; |
| | $col_name ='website_name'; |
| | $col_pic=$param['col']==2 ? 'website_content' :'website_pic'; |
| | $col_time='website_time'; |
| | } |
| | else{ |
| | return $this->error(lang('param_err')); |
| | } |
| |
|
| | $where = ' 1=1 '; |
| | if ($param['range'] =="2" && $param['date']!=""){ |
| | $pic_fwdate = str_replace('|','-',$param['date']); |
| | $todayunix1 = strtotime($pic_fwdate); |
| | $todayunix2 = $todayunix1 + 86400; |
| | $where .= ' AND ('.$col_time.'>= '. $todayunix1 . ' AND '.$col_time.'<='. $todayunix2 .') '; |
| | } |
| | if($param['col'] == 2){ |
| | $where .= ' and '. $col_pic . " like '%<img%src=\"http%' "; |
| | } |
| | else { |
| | if ($param['opt'] == 1) { |
| | $where .= " AND instr(" . $col_pic . ",'#err')=0 "; |
| | } elseif ($param['opt'] == 2) { |
| | $where .= " AND instr(" . $col_pic . ",'" . $flag . "')=0 "; |
| | } elseif ($param['opt'] == 3) { |
| | $where .= " AND instr(" . $col_pic . ",'#err')>0 "; |
| | } |
| | $where .= " AND instr(" . $col_pic . ",'http')>0 "; |
| | } |
| |
|
| | $total = Db::name($tab)->where($where)->count(); |
| | $page_count = ceil($total / $param['limit']); |
| |
|
| | if($total==0){ |
| | mac_echo(lang('admin/images/sync_complete')); |
| | exit; |
| | } |
| |
|
| | mac_echo('<style type="text/css">body{font-size:12px;color: #333333;line-height:21px;}span{font-weight:bold;color:#FF0000}</style>'); |
| | mac_echo(lang('admin/images/sync_tip',[$total,$param['limit'],$page_count,$param['page']])); |
| |
|
| | $list = Db::name($tab)->where($where)->page($page_count-1,$param['limit'])->select(); |
| | $config = config('maccms.upload'); |
| |
|
| | if ($config['mode'] == '2') { |
| | $config['mode'] = 'upyun'; |
| | } |
| | elseif ($config['mode'] == '3'){ |
| | $config['mode'] = 'qiniu'; |
| | } |
| | elseif ($config['mode'] == '4') { |
| | $config['mode'] = 'ftp'; |
| | } |
| | elseif ($config['mode'] == '5') { |
| | $config['mode'] = 'weibo'; |
| | } |
| |
|
| |
|
| | foreach($list as $k=>$v){ |
| |
|
| | mac_echo($v[$col_id].'、'.$v[$col_name]); |
| |
|
| | if($param['col'] == 2){ |
| | $content = $v[$col_pic]; |
| | $rule = mac_buildregx('<img[^>]*src=[\'"]?([^>\'"\s]*)[\'"]?[^>]*>',"is"); |
| | preg_match_all($rule,$content,$matches); |
| | $matchfieldarr=$matches[1]; |
| | $matchfieldstrarr=$matches[0]; |
| | $matchfieldvalue=""; |
| | foreach($matchfieldarr as $f=>$matchfieldstr) |
| | { |
| | $matchfieldvalue=$matchfieldstrarr[$f]; |
| | $img_old = trim(preg_replace("/[ \r\n\t\f]{1,}/"," ",$matchfieldstr)); |
| | $img_url = model('Image')->down_load($img_old, $config, $param['tab']); |
| |
|
| | $des = ''; |
| | if(in_array($config['mode'],['local']) || substr($img_url,0,7)=='upload/'){ |
| | $img_url = MAC_PATH . $img_url; |
| | $link = $img_url; |
| | $link = str_replace('//', '/', $link); |
| | } |
| | else{ |
| | $link = str_replace('mac:', $config['protocol'].':', $img_url); |
| | } |
| | if ($img_url == $img_old) { |
| | $des = '<a href="' . $link . '" target="_blank">' . $link . '</a><font color=red>'.lang('download_err').'!</font>'; |
| | $img_url .= $flag; |
| | $content = str_replace($img_old,"",$content); |
| | } else { |
| | $des = '<a href="' . $link . '" target="_blank">' . $link . '</a><font color=green>'.lang('download_ok').'!</font>'; |
| | $content = str_replace($img_old, $img_url, $content ); |
| | } |
| | mac_echo($des); |
| | } |
| |
|
| | $where = []; |
| | $where[$col_id] = $v[$col_id]; |
| | $update = []; |
| | $update[$col_pic] = $content; |
| | $st = Db::name($tab)->where($where)->update($update); |
| | } |
| | else { |
| | $img_old = $v[$col_pic]; |
| | if (strpos($img_old, "#err")) { |
| | $picarr = explode("#err", $img_old); |
| | $img_old = $picarr[0]; |
| | } |
| |
|
| | $img_url = model('Image')->down_load($img_old, $config, $param['tab']); |
| | $des = ''; |
| | if(in_array($config['mode'],['local']) || substr($img_url,0,7)=='upload/'){ |
| | $link = MAC_PATH . $img_url; |
| | $link = str_replace('//', '/', $link); |
| | } |
| | else{ |
| | $link = str_replace('mac:', $config['protocol'].':', $img_url); |
| | } |
| |
|
| | if ($img_url == $img_old) { |
| | $des = '<a href="' . $img_old . '" target="_blank">' . $img_old . '</a><font color=red>'.lang('download_err').'!</font>'; |
| | $img_url .= $flag; |
| | } else { |
| | $des = '<a href="' . $link . '" target="_blank">' . $link . '</a><font color=green>'.lang('download_ok').'!</font>'; |
| | } |
| | mac_echo($des); |
| |
|
| | $where = []; |
| | $where[$col_id] = $v[$col_id]; |
| | $update = []; |
| | $update[$col_pic] = $img_url; |
| | $st = Db::name($tab)->where($where)->update($update); |
| | } |
| | } |
| |
|
| | $url = url('images/sync') .'?'. http_build_query($param); |
| | mac_jump( $url ,3); |
| | } |
| |
|
| |
|
| | } |
| |
|
