public function actionCheck($id = null) { if ($_SERVER['REQUEST_METHOD'] == 'POST') { $id = $_POST['List']['collect_list_id']; } $ids = is_array($id) ? $id : array($id); $ids = array_filter($ids); if (!count($ids)) { $this->redirect[] = array('text' => '', 'href' => $_SERVER['HTTP_REFERER']); $this->message('请选择至少一项进行操作!', self::MSG_SUCCESS, true); } $value = intval($_REQUEST['value']) ? 1 : 0; //1审核0取消审核 foreach ($ids as $id) { $list = CollectList::get_list_by_id($id, false); $task = CollectTask::get_task_by_id($list['collect_task_id'], false); $template = CollectTemplate::get_template_by_id($task['collect_template_id'], false); if ($value) { /*$sql = "INSERT INTO {{game_media_data}} SET `media_data_subject`='{$list[collect_list_title]}', `media_data_href`='$list[collect_list_url]', `media_data_thumb`='$list[collect_list_thumb]', `media_data_dateline`=".time().", `game_id`='{$list[game_id]}', `content_class_id`='{$task[content_class_id]}', `media_data_source`='{$template[collect_source_id]}', `collect_data_time`=".strtotime($list['collect_list_day']) ; $_cmd->execute();*/ $_cmd = Yii::app()->db->createCommand()->insert('{{game_media_data}}', array('media_data_subject' => $list[collect_list_title], 'media_data_href' => $list[collect_list_url], 'media_data_thumb' => $list[collect_list_thumb], 'media_data_dateline' => time(), 'game_id' => $list[game_id], 'content_class_id' => $task[content_class_id], 'media_data_source' => $template[collect_source_id], 'collect_data_time' => strtotime($list['collect_list_day']))); $media_data_id = Yii::app()->db->getLastInsertID(); } else { //取消审核 $media_data_id = 0; if ($list["media_data_id"]) { $sql = "DELETE FROM {{game_media_data}} WHERE media_data_id={$list[media_data_id]}"; $_cmd = Yii::app()->db->createCommand($sql); $_cmd->execute(); } } $_sql = "UPDATE {{collect_list}} SET `collect_list_check`={$value},`media_data_id`={$media_data_id} WHERE collect_list_id={$id}"; $_cmd = Yii::app()->db->createCommand($_sql); $_cmd->execute(); } if (!isset($_GET['ajax'])) { $this->redirect[] = array('text' => '', 'href' => $_SERVER['HTTP_REFERER']); $this->message('操作成功', self::MSG_SUCCESS, true); } }
/** * 采集入库 * @param int $id (collect_list_id) */ public function actionPut($id) { $mixdata = CollectList::get_list_model_by_id($id); //将collect_task collect_list collect_model content_model 数据取出来 $collect_task = $mixdata['collect_task']; $collect_list = $mixdata['collect_list']; $collect_model = $mixdata['collect_model']; $content_model = $mixdata['content_model']; $collect_fields = CollectFields::get_fields_by_model_id($collect_model['collect_model_id']); //可变化的字段 $tmpfields = $this->ContentReg($collect_list['collect_task_id'], $collect_list['collect_list_url'], $collect_task); foreach ($tmpfields as $k => $v) { $collect = CollectFields::get_fields_by_id($v['identify']); $collect_task[$collect['collect_fields_identify']] = $v['value']; } $archive = array('content_archives_id' => 0, 'content_archives_subject' => $collect_list['collect_list_title'], 'content_archives_color' => '', 'content_archives_short_subject' => '', 'content_archives_flag' => array(), 'content_archives_tags' => array(), 'content_archives_classes' => array(), 'content_model_colums' => ContentModel::get_model_table_by_id($content_model['content_model_id']), 'content_archives_rank' => 255, 'content_archives_pubtime' => date('Y-m-d H:i:s', $_SERVER['REQUEST_TIME'])); $_model = ContentModel::get_model_by_id($content_model['content_model_id']); foreach ($collect_fields as $_k => $_v) { $archive[$_v['content_model_field_identify']] = $collect_task[$_v['collect_fields_identify']]; } $_edit_template = $_model['content_model_edit_template'] ? $_model['content_model_edit_template'] : 'default'; $this->render("_{$_edit_template}_create", array('_edit_template' => $_edit_template, 'archive' => $archive, 'classes' => ContentArchivesClass::get_classes_by_cache())); }