public function get_pic_detail() { $pic_id = intval($_GET['pic_id']); $pic_item = MeiuiPic::find('id = ' . $pic_id); if (count($pic_item)) { foreach ($pic_item as $value) { $user = MeiuiUser::findFirst('id=' . $value->create_user); $tags = MeiuiPicLinkTag::find('pic_id=' . $value->id); $sys_tag = []; $user_tag = []; if (count($tags) > 0) { foreach ($tags as $v) { if (in_array($v->pic_id, $this->user_tag_array['del_flag'][$v->tag_id])) { $user_tag[] = $v->tag_name; if ($v->tag_type == 2) { $sys_tag[] = $v->tag_name; } } else { if ($v->tag_type == 2) { $sys_tag[] = $v->tag_name; } } } } $this->main['data']['items'][] = array('pic_id' => $value->id, 'pic' => $value->pic_url, 'pic_h' => $value->pic_h, 'pic_w' => $value->pic_w, 'app_id' => $value->app_id, 'user_id' => $value->create_user, 'user_name' => $user->username, 'user_pic' => $user->user_pic, 'app_name' => $value->app_name, 'brief' => $value->brief, 'sys_tag' => $sys_tag, 'user_tag' => $user_tag); } $this->main['alert']['msg'] = $this->lang['request_success']; } else { $this->main['alert']['msg'] = '不存在图片'; } die(json_encode($this->main)); }
public function search() { $data = $this->main; $page = 1; if (isset($_GET['page'])) { $page = intval($_GET['page']); } $this->set_search_history(); $keyword = $_GET['keyword']; $conditions = " tag_name LIKE :tag_name: group by pic_id"; $parameters = array("tag_name" => '%' . $keyword . '%'); $all_pic = MeiuiPicLinkTag::find(array($conditions, "bind" => $parameters)); $paginator = new Paginator(array("data" => $all_pic, "limit" => 10, "page" => $page)); $all_pic = $paginator->getPaginate(); $data['status'] = '200200'; $data['data']['page'] = $all_pic->current . '/' . $all_pic->total_pages; $login_user_id = intval($_GET['user_id']); $login_user_collect = MeiuiUserTag::find('user_id = ' . $login_user_id . ' and del_flag = 1 '); $login_collect_tag = []; if (count($login_user_collect) > 0) { foreach ($login_user_collect as $collect) { $login_collect_tag[] = $collect->tag_id; } } foreach ($all_pic->items as $pic_value) { $pic = MeiuiPic::findFirst('id=' . $pic_value->pic_id); if ($pic) { $user = MeiuiUser::findFirst('id=' . $pic->create_user); $tags = MeiuiPicLinkTag::find('pic_id=' . $pic->id); $sys_tag = []; $user_tag = []; if (count($tags) > 0) { foreach ($tags as $v) { if (in_array($v->pic_id, $this->user_tag_array['del_flag'][$v->tag_id])) { $user_tag[] = $v->tag_name; if ($v->tag_type == 2) { $sys_tag[] = $v->tag_name; } } else { if ($v->tag_type == 2) { $sys_tag[] = $v->tag_name; } } } } $data['data']['items'][] = array('pic_id' => $pic->id, 'pic' => $pic->pic_url, 'pic_h' => $pic->pic_h, 'pic_w' => $pic->pic_w, 'app_id' => $pic->app_id, 'user_id' => $pic->create_user, 'user_name' => $user->username, 'user_pic' => $user->user_pic, 'app_name' => $pic->app_name, 'brief' => $pic->brief, 'sys_tag' => $sys_tag, 'user_tag' => $user_tag); } } $data['alert']['msg'] = $this->lang['request_success']; die(json_encode($data)); }
public function pic_item($pic_id) { $pic = MeiuiPic::findFirst('id=' . $pic_id); $user = MeiuiUsers::findFirst('id=' . $pic->create_user); $tags = MeiuiPicLinkTag::find('pic_id=' . $pic_id); $tag = ''; if (count($tags) > 0) { foreach ($tags as $v) { $tag .= $v->tag_name . ','; } } $pic_item = array('user_id' => $pic->create_user, 'user_name' => $user->username, 'user_pic' => $user->user_pic, 'pic' => $pic->pic_url, 'pic_h' => $pic->pic_h, 'pic_w' => $pic->pic_w, 'app_id' => $pic->app_id, 'app_name' => $pic->app_name, 'brief' => $pic->brief, 'tag' => $tag); return $pic_item; }
public function insert_tag_link_pic($tag_name, $pic_id) { $tag = $this->insert_tag($tag_name); $conditions = " tag_name = :tag_name: and pic_id =:pic_id:"; $parameters = array("tag_name" => $tag->tag_name, "pic_id" => $pic_id); $db_tag_link_pic = MeiuiPicLinkTag::findFirst(array($conditions, "bind" => $parameters)); if (!$db_tag_link_pic) { $db_tag_link_pic = new MeiuiPicLinkTag(); $db_tag_link_pic->pic_id = $pic_id; $db_tag_link_pic->user_id = $_SESSION['auth']['id']; $db_tag_link_pic->tag_id = $tag->id; $db_tag_link_pic->tag_name = $tag->tag_name; $db_tag_link_pic->save(); } return $db_tag_link_pic; }
private function del_tag_link_pic($pic_id, $tag_id) { $conditions = " tag_id = :tag_id: and pic_id = :pic_id: and del_flag = 1 "; $parameters = array("tag_id" => $tag_id, "pic_id" => $pic_id); $user_tag = MeiuiUserTag::find(array($conditions, "bind" => $parameters)); if ($user_tag) { $conditions = " tag_id = :tag_id: and pic_id =:pic_id:"; $parameters = array("tag_id" => $tag_id, "pic_id" => $pic_id); $db_tag_link_pic = MeiuiPicLinkTag::findFirst(array($conditions, "bind" => $parameters)); if ($db_tag_link_pic) { $db_tag_link_pic->delete(); } } }