phpcms后台批量上传添加图片文章方法详解（二）

点击次数：更新时间：2014-04-04 16:04:31【打印】【关闭】

继续上篇的《 phpcms后台批量上传添加图片文章方法详解（一） 》的修改。

四、增加批量添加插入数据库函数addall_content()

打开“phpcms\model\content_model.class.php”文件，搜索“public function add_content”函数，在该函数的后面添加以下代码：

        /**
   * 添加内容
   *
   * @param $datas
   * @param $isimport 是否为外部接口导入
   */
   public function addall_content($data,$isimport = 0) {
       if($isimport) $data = new_addslashes($data);
       $this->search_db = pc_base::load_model('search_model');
       $modelid = $this->modelid;
       require_once CACHE_MODEL_PATH.'content_input.class.php';
        require_once CACHE_MODEL_PATH.'content_update.class.php';
       $content_input = new content_input($this->modelid);
       $inputinfo = $content_input->get($data,$isimport);

       $systeminfo = $inputinfo['system'];
       $modelinfo = $inputinfo['model'];

       if($data['inputtime'] && !is_numeric($data['inputtime'])) {
           $systeminfo['inputtime'] = strtotime($data['inputtime']);
       } elseif(!$data['inputtime']) {
           $systeminfo['inputtime'] = SYS_TIME;
       } else {
           $systeminfo['inputtime'] = $data['inputtime'];
       }

       //读取模型字段配置中，关于日期配置格式，来组合日期数据
       $this->fields = getcache('model_field_'.$modelid,'model');
       $setting = string2array($this->fields['inputtime']['setting']);
       extract($setting);
       if($fieldtype=='date') {
           $systeminfo['inputtime'] = date('Y-m-d');
       }elseif($fieldtype=='datetime'){
            $systeminfo['inputtime'] = date('Y-m-d H:i:s');
       }

       if($data['updatetime'] && !is_numeric($data['updatetime'])) {
           $systeminfo['updatetime'] = strtotime($data['updatetime']);
       } elseif(!$data['updatetime']) {
           $systeminfo['updatetime'] = SYS_TIME;
       } else {
           $systeminfo['updatetime'] = $data['updatetime'];
       }
       $systeminfo['username'] = $data['username'] ? $data['username'] : param::get_cookie('admin_username');
       $systeminfo['sysadd'] = defined('IN_ADMIN') ? 1 : 0;

       //自动提取摘要
       if(isset($_POST['add_introduce']) && $systeminfo['description'] == '' && isset($modelinfo['content'])) {
           $content = stripslashes($modelinfo['content']);
           $introcude_length = intval($_POST['introcude_length']);
           $systeminfo['description'] = str_cut(str_replace(array("'","\r\n","\t",'[page]','[/page]','“','”',' '), '', strip_tags($content)),$introcude_length);
           $inputinfo['system']['description'] = $systeminfo['description'] = addslashes($systeminfo['description']);
       }
       //自动提取缩略图
       if(isset($_POST['auto_thumb']) && $systeminfo['thumb'] == '' && isset($modelinfo['content'])) {
           $content = $content ? $content : stripslashes($modelinfo['content']);
           $auto_thumb_no = intval($_POST['auto_thumb_no'])-1;
           if(preg_match_all("/(src)=([\"|']?)([^ \"'>]+\.(gif|jpg|jpeg|bmp|png))\\2/i", $content, $matches)) {
               $systeminfo['thumb'] = $matches[3][$auto_thumb_no];
           }
       }
       $systeminfo['description'] = str_replace(array('/','\\','#','.',"'"),' ',$systeminfo['description']);
       $systeminfo['keywords'] = str_replace(array('/','\\','#','.',"'"),' ',$systeminfo['keywords']);

       //主表
       $tablename = $this->table_name = $this->db_tablepre.$this->model_tablename;


       $inputinfo = $content_input->get($data,$isimport);


       $title01 = $inputinfo['system']['title01'];
       $title02 = $inputinfo['system']['title02'];
       $title03 = $inputinfo['system']['title03'];
       $title04 = $inputinfo['system']['title04'];
       $title05 = $inputinfo['system']['title05'];




       $suolve01 = $inputinfo['system']['suolve01'];
       $suolve02 = $inputinfo['system']['suolve02'];
       $suolve03 = $inputinfo['system']['suolve03'];
       $suolve04 = $inputinfo['system']['suolve04'];
       $suolve05 = $inputinfo['system']['suolve05'];


       $catid = $inputinfo['system']['catid'];

       $systeminfo1 = array('catid' => $catid,'title' => $title01,'thumb' => $suolve01);
       $systeminfo2 = array('catid' => $catid,'title' => $title02,'thumb' => $suolve02);
       $systeminfo3 = array('catid' => $catid,'title' => $title03,'thumb' => $suolve03);
       $systeminfo4 = array('catid' => $catid,'title' => $title04,'thumb' => $suolve04);
       $systeminfo5 = array('catid' => $catid,'title' => $title05,'thumb' => $suolve05);

       $id = $modelinfo['id'] = $this->insert($systeminfo1,true);
       $id1 = $modelinfo['id'] = $this->insert($systeminfo2,true);
       $id2 = $modelinfo['id'] = $this->insert($systeminfo3,true);
       $id3 = $modelinfo['id'] = $this->insert($systeminfo4,true);
       $id4 = $modelinfo['id'] = $this->insert($systeminfo5,true);




       //$id = $modelinfo['id'] = $this->insert($systeminfo,true);




       //print_r( $systeminfo);
       $this->update($systeminfo,array('id'=>$id));
       $this->update($systeminfo,array('id'=>$id1));
       $this->update($systeminfo,array('id'=>$id2));
       $this->update($systeminfo,array('id'=>$id3));
       $this->update($systeminfo,array('id'=>$id4));
       //更新URL地址
       if($data['islink']==1) {
           $urls[0] = trim_script($_POST['linkurl']);
           $urls[0] = str_replace(array('select ',')','\\','#',"'"),' ',$urls[0]);
       } else {
           $urls = $this->url->show($id, 0, $systeminfo['catid'], $systeminfo['inputtime'], $data['prefix'],$inputinfo,'add');
           $urls1 = $this->url->show($id1, 0, $systeminfo['catid'], $systeminfo['inputtime'], $data['prefix'],$inputinfo,'add');
           $urls2 = $this->url->show($id2, 0, $systeminfo['catid'], $systeminfo['inputtime'], $data['prefix'],$inputinfo,'add');
           $urls3 = $this->url->show($id3, 0, $systeminfo['catid'], $systeminfo['inputtime'], $data['prefix'],$inputinfo,'add');
           $urls4 = $this->url->show($id4, 0, $systeminfo['catid'], $systeminfo['inputtime'], $data['prefix'],$inputinfo,'add');
       }
       $this->table_name = $tablename;
       $this->update(array('url'=>$urls[0]),array('id'=>$id));
       $this->update(array('url'=>$urls1[0]),array('id'=>$id1));
       $this->update(array('url'=>$urls2[0]),array('id'=>$id2));
       $this->update(array('url'=>$urls3[0]),array('id'=>$id3));
       $this->update(array('url'=>$urls4[0]),array('id'=>$id4));



       //附属表
       $this->table_name = $this->table_name.'_data';
       $this->insert($modelinfo);
       //添加统计
       $this->hits_db = pc_base::load_model('hits_model');
       $hitsid = 'c-'.$modelid.'-'.$id;
       $hitsid1 = 'c-'.$modelid.'-'.$id1;
       $hitsid2 = 'c-'.$modelid.'-'.$id2;
       $hitsid3 = 'c-'.$modelid.'-'.$id3;
       $hitsid4 = 'c-'.$modelid.'-'.$id4;




       $this->hits_db->insert(array('hitsid'=>$hitsid,'catid'=>$systeminfo['catid'],'updatetime'=>SYS_TIME));
       $this->hits_db->insert(array('hitsid'=>$hitsid1,'catid'=>$systeminfo['catid'],'updatetime'=>SYS_TIME));
       $this->hits_db->insert(array('hitsid'=>$hitsid2,'catid'=>$systeminfo['catid'],'updatetime'=>SYS_TIME));
       $this->hits_db->insert(array('hitsid'=>$hitsid3,'catid'=>$systeminfo['catid'],'updatetime'=>SYS_TIME));
       $this->hits_db->insert(array('hitsid'=>$hitsid4,'catid'=>$systeminfo['catid'],'updatetime'=>SYS_TIME));



       if($data['status']==99) {
           //更新到全站搜索
           $this->search_api($id,$inputinfo);
       }
       //更新栏目统计数据
       $this->update_category_items($systeminfo['catid'],'add',1);
       //调用 update
       $content_update = new content_update($this->modelid,$id);
       $content_update1 = new content_update($this->modelid,$id1);
       $content_update2 = new content_update($this->modelid,$id2);
       $content_update3 = new content_update($this->modelid,$id3);
       $content_update4 = new content_update($this->modelid,$id4);
       //合并后，调用update
       $merge_data = array_merge($systeminfo,$modelinfo);
       $merge_data['posids'] = $data['posids'];
       $content_update->update($merge_data);
       $content_update1->update($merge_data);
       //发布到审核列表中
       if(!defined('IN_ADMIN') || $data['status']!=99) {
           $this->content_check_db = pc_base::load_model('content_check_model');
           $check_data = array(
               'checkid'=>'c-'.$id.'-'.$modelid,
               'catid'=>$systeminfo['catid'],
               'siteid'=>$this->siteid,
               'title'=>$systeminfo['title'],
               'username'=>$systeminfo['username'],
               'inputtime'=>$systeminfo['inputtime'],
               'status'=>$data['status'],
               );
           $this->content_check_db->insert($check_data);
       }
       //END发布到审核列表中
       if(!$isimport) {
           $html = pc_base::load_app_class('html', 'content');
           $urls['data']['system']['id'] = $id;
           $urls1['data']['system']['id'] = $id1;
           $urls2['data']['system']['id'] = $id2;
           $urls3['data']['system']['id'] = $id3;
           $urls4['data']['system']['id'] = $id4;
           if($urls['content_ishtml'] && $data['status']==99) $html->show($urls[1],$urls['data']);
           if($urls1['content_ishtml'] && $data['status']==99) $html->show($urls1[1],$urls['data']);
           if($urls2['content_ishtml'] && $data['status']==99) $html->show($urls2[1],$urls['data']);
           if($urls3['content_ishtml'] && $data['status']==99) $html->show($urls3[1],$urls['data']);
           if($urls4['content_ishtml'] && $data['status']==99) $html->show($urls4[1],$urls['data']);
           $catid = $systeminfo['catid'];
       }
       //发布到其他栏目
       if($id && isset($_POST['othor_catid']) && is_array($_POST['othor_catid'])) {
           $linkurl = $urls[0];
           $r = $this->get_one(array('id'=>$id));
           foreach ($_POST['othor_catid'] as $cid=>$_v) {
               $this->set_catid($cid);
               $mid = $this->category[$cid]['modelid'];
               if($modelid==$mid) {
                   //相同模型的栏目插入新的数据
                   $inputinfo['system']['catid'] = $systeminfo['catid'] = $cid;
                   $newid = $modelinfo['id'] = $this->insert($systeminfo,true);
                   $this->table_name = $tablename.'_data';
                   $this->insert($modelinfo);
                   if($data['islink']==1) {
                       $urls = $_POST['linkurl'];
                       $urls = str_replace(array('select ',')','\\','#',"'"),' ',$urls);
                   } else {
                       $urls = $this->url->show($newid, 0, $cid, $systeminfo['inputtime'], $data['prefix'],$inputinfo,'add');
                   }
                   $this->table_name = $tablename;
                   $this->update(array('url'=>$urls[0]),array('id'=>$newid));
                   //发布到审核列表中
                   if($data['status']!=99) {
                       $check_data = array(
                           'checkid'=>'c-'.$newid.'-'.$mid,
                           'catid'=>$cid,
                           'siteid'=>$this->siteid,
                           'title'=>$systeminfo['title'],
                           'username'=>$systeminfo['username'],
                           'inputtime'=>$systeminfo['inputtime'],
                           'status'=>1,
                           );
                       $this->content_check_db->insert($check_data);
                   }
                   if($urls['content_ishtml'] && $data['status']==99) $html->show($urls[1],$urls['data']);
               } else {
                   //不同模型插入转向链接地址
                   $newid = $this->insert(
                   array('title'=>$systeminfo['title'],
                       'style'=>$systeminfo['style'],
                       'thumb'=>$systeminfo['thumb'],
                       'keywords'=>$systeminfo['keywords'],
                       'description'=>$systeminfo['description'],
                       'status'=>$systeminfo['status'],
                       'catid'=>$cid,'url'=>$linkurl,
                       'sysadd'=>1,
                       'username'=>$systeminfo['username'],
                       'inputtime'=>$systeminfo['inputtime'],
                       'updatetime'=>$systeminfo['updatetime'],
                       'islink'=>1
                   ),true);
                   $this->table_name = $this->table_name.'_data';
                   $this->insert(array('id'=>$newid));
                   //发布到审核列表中
                   if($data['status']!=99) {
                       $check_data = array(
                           'checkid'=>'c-'.$newid.'-'.$mid,
                           'catid'=>$systeminfo['catid'],
                           'siteid'=>$this->siteid,
                           'title'=>$systeminfo['title'],
                           'username'=>$systeminfo['username'],
                           'inputtime'=>$systeminfo['inputtime'],
                           'status'=>1,
                           );
                       $this->content_check_db->insert($check_data);
                   }
               }
               $hitsid = 'c-'.$mid.'-'.$newid;
               $this->hits_db->insert(array('hitsid'=>$hitsid,'catid'=>$cid,'updatetime'=>SYS_TIME));
           }
       }
       //END 发布到其他栏目
       //更新附件状态
       if(pc_base::load_config('system','attachment_stat')) {
           $this->attachment_db = pc_base::load_model('attachment_model');
           $this->attachment_db->api_update('','c-'.$systeminfo['catid'].'-'.$id,2);
       }
       //生成静态
       if(!$isimport && $data['status']==99) {
           //在添加和修改内容处定义了 INDEX_HTML
           if(defined('INDEX_HTML')) $html->index();
           if(defined('RELATION_HTML')) $html->create_relation_html($catid);
       }
       return $id;
   }

完成后效果如下图：

增加批量添加插入数据库函数

五、在图片模型中添加批量添加字段

进入网站后台---内容---模型管理--图片模型--字段管理，添加相应的批量添加字段，这里的字段值一定要和“content_addall.tpl.php”和“content.php”中的值一样，否则会出现错误，完成后效果如图所示：

在图片模型中添加批量添加字段

六、将单条添加中的批量上传字段进行隐藏处理

为了能够达到更好的用户体验，需要将单条添加的时候，批量上传中用到的字段隐藏掉，打开“phpcms\modules\content\templates\content_add.tpl.php”文件，搜索“<th width="80"><?php if($info['star']){ ?> <font color="red">*</font><?php } ?> <?php echo $info['name']?>”，在句话<tr>的上面增加判断，效果图下图：

将单条添加中的批量上传字段进行隐藏处理

写到最后：

至此PHPCMS后台批量添加图片模型文章的方法已经完成，只不过还有一点细节的部分需要调整，比如在添加完五条信息之后，在返回进行编辑的时候，会出现信息为空的现象，这点不会影响批量添加的使用，有兴趣的同学可以再进行修改，以达到更佳完美的效果图，作为济南网站建设公司的一员，尽量保证我们所做的每个网站的后台最适宜用户的使用，就比如这个批量添加的功能，如果您不给客户添加上，可能会浪费自己或者客户很多时间，而且客户也会觉得自己花钱建设的网站没有达到完美。

相关阅读：

phpcms后台批量上传添加图片文章方法详解（一）

网站建设中phpcms点击数jquery发生冲突不显示解决办法

济南网站制作phpcmsV9文件上传大小限制修改完整版

济南网站制作phpcmsV9二级下拉分类调用

济南网站建设，phpcmsV9联动菜单的实现方法

phpcms v9升级后台无法上传缩略图的原因分析

上一条:利用清明节长假提升济南网站建设关键字排名下一条:phpcms后台批量上传添加图片文章方法详解（一）