/** * @brief 用户筛选 */ function member_filter() { $search = IFilter::string(IReq::get('search')); $keywords = IFilter::string(IReq::get('keywords')); $where = ' 1 '; if ($search && $keywords) { $where .= " and {$search} like '%{$keywords}%' "; } $this->data['search'] = $search; $this->data['keywords'] = $keywords; $this->data['where'] = $where; $tb_user_group = new IModel('user_group'); $data_group = $tb_user_group->query(); $data_group = is_array($data_group) ? $data_group : array(); $group = array(); foreach ($data_group as $value) { $group[$value['id']] = $value['group_name']; } $this->data['group'] = $group; $page = IReq::get('page'); $page = intval($page) ? intval($page) : 1; $and = ' and '; $where = 'm.status="1"' . $and; $group_key = IFilter::string(IReq::get('group_key')); $group_v = IFilter::act(IReq::get('group_value'), 'int'); if ($group_key && $group_v) { if ($group_key == 'eq') { $where .= "m.group_id='{$group_v}' {$and}"; } else { $where .= "m.group_id!='{$group_v}' {$and} "; } } $username_key = IFilter::string(IReq::get('username_key')); $username_v = IFilter::act(IReq::get('username_value'), 'string'); if ($username_key && $username_v) { if ($username_key == 'eq') { $where .= "u.username='******' {$and}"; } else { $where .= 'u.username like "%' . $username_v . '%"' . $and; } } $truename_key = IFilter::string(IReq::get('truename_key')); $truename_v = IFilter::act(IReq::get('truename_value'), 'string'); if ($truename_key && $truename_v) { if ($truename_key == 'eq') { $where .= "m.true_name='{$truename_v}' {$and}"; } else { $where .= 'm.true_name like "%' . $truename_v . '%"' . $and; } } $mobile_key = IFilter::string(IReq::get('mobile_key')); $mobile_v = IFilter::act(IReq::get('mobile_value'), 'string'); if ($mobile_key && $mobile_v) { if ($mobile_key == 'eq') { $where .= "m.mobile='{$mobile_v}' {$and} "; } else { $where .= 'm.mobile like "%' . $mobile_v . '%"' . $and; } } $telephone_key = IFilter::string(IReq::get('telephone_key')); $telephone_v = IFilter::act(IReq::get('telephone_value'), 'string'); if ($telephone_key && $telephone_v) { if ($telephone_key == 'eq') { $where .= "m.telephone='{$telephone_v}' {$and} "; } else { $where .= 'm.telephone like "%' . $telephone_v . '%"' . $and; } } $email_key = IFilter::string(IReq::get('email_key')); $email_v = IFilter::act(IReq::get('email_value'), 'string'); if ($email_key && $email_v) { if ($email_key == 'eq') { $where .= "u.email='{$email_v}' {$and} "; } else { $where .= 'u.email like "%' . $email_v . '%"' . $and; } } $zip_key = IFilter::string(IReq::get('zip_key')); $zip_v = IFilter::act(IReq::get('zip_value'), 'string'); if ($zip_key && $zip_v) { if ($zip_key == 'eq') { $where .= "m.zip='{$zip_v}' {$and} "; } else { $where .= 'm.zip like "%' . $zip_v . '%"' . $and; } } $sex = intval(IReq::get('sex')); if ($sex && $sex != '-1') { $where .= 'm.sex=' . $sex . $and; } $point_key = IFilter::string(IReq::get('point_key')); $point_v = intval(IReq::get('point_value')); if ($point_key && $point_v) { if ($point_key == 'eq') { $where .= 'm.point= "' . $point_v . '"' . $and; } elseif ($point_key == 'gt') { $where .= 'm.point > "' . $point_v . '"' . $and; } else { $where .= 'm.point < "' . $point_v . '"' . $and; } } $regtimeBegin = IFilter::string(IReq::get('regtimeBegin')); if ($regtimeBegin) { $where .= 'm.time > "' . $regtimeBegin . '"' . $and; } $regtimeEnd = IFilter::string(IReq::get('regtimeEnd')); if ($regtimeEnd) { $where .= 'm.time < "' . $regtimeEnd . '"' . $and; } $where .= ' 1 '; $query = new IQuery("member as m"); $query->join = "left join user as u on m.user_id = u.id left join user_group as gp on m.group_id = gp.id"; $query->fields = "m.*,u.username,u.email,gp.group_name"; $query->where = $where; $query->page = $page; $query->pagesize = "20"; $this->data['member_list'] = $query->find(); $this->data['pageBar'] = $query->getPageBar('/member/member_filter/'); $this->setRenderData($this->data); $this->redirect('member_filter'); }
?> " title="删除" /> </a> <?php } ?> </td> </tr> <?php } ?> </tbody> </table> </div> <?php echo $query->getPageBar(); ?> <script type="text/javascript"> //表单回填 var formObj = new Form('searchBill'); <?php foreach ($search as $key => $item) { ?> formObj.setValue("search[<?php echo isset($key) ? $key : ""; ?> ]","<?php echo isset($item) ? $item : ""; ?> ");
/** * @brief 到货通知筛选 */ function notify_filter() { $search = IReq::get('search'); $keywords = IReq::get('keywords'); $where = ' 1 '; if ($search && $keywords) { $where .= " and {$search} like '%{$keywords}%' "; } $this->data['search'] = $search; $this->data['keywords'] = $keywords; $this->data['where'] = $where; $page = IReq::get('page'); $page = intval($page) ? intval($page) : 1; $and = ' and '; $where = ''; $goodsname_k = IFilter::string(IReq::get('goodsname_k')); $goodsname_v = IFilter::string(IReq::get('goodsname_v')); if ($goodsname_k && $goodsname_v) { if ($goodsname_k == 'eq') { $where .= 'goods.name="' . $goodsname_v . '"' . $and; } else { $where .= 'goods.name like "%' . $goodsname_v . '%"' . $and; } } $username_k = IFilter::string(IReq::get('username_k')); $username_v = IFilter::string(IReq::get('username_v')); if ($username_k && $username_v) { if ($username_k == 'eq') { $where .= 'u.username="******"' . $and; } else { $where .= 'u.username like "%' . $username_v . '%"' . $and; } } $store_nums_k = IFilter::string(IReq::get('store_nums_k')); $stror_nums_v = intval(IReq::get('store_nums_v')) ? intval(IReq::get('store_nums_v')) : 0; if ($store_nums_k) { if ($store_nums_k == 'gt') { $where .= 'goods.store_nums > "' . $stror_nums_v . '"' . $and; } elseif ($store_nums_k == 'eq') { $where .= 'goods.store_nums = "' . $stror_nums_v . '"' . $and; } else { $where .= 'goods.store_nums < "' . $stror_nums_v . '"' . $and; } } $email_k = IFilter::string(IReq::get('email_k')); $email_v = IFilter::string(IReq::get('email_v')); if ($email_k && $email_v) { if ($email_k == 'gt') { $where .= 'notify.email = "' . $email_v . '"' . $and; } else { $where .= 'notify.email like "%' . $email_v . '%"' . $and; } } $regtimeBegin = IFilter::string(IReq::get('regtimeBegin')); if ($regtimeBegin) { $where .= 'notify.register_time > "' . $regtimeBegin . '"' . $and; } $regtimeEnd = IFilter::string(IReq::get('regtimeEnd')); if ($regtimeEnd) { $where .= 'notify.register_time < "' . $regtimeEnd . '"' . $and; } $status = intval(IReq::get('status')); if ($status && $status != '-1') { $where .= 'notify.notify_status = "' . $status . '"' . $and; } $where .= ' 1 '; $query = new IQuery("notify_registry as notify"); $query->join = "join goods as goods on notify.goods_id = goods.id left join user as u on notify.user_id = u.id"; $query->fields = "notify.*,u.username,goods.name as goods_name,goods.store_nums"; $query->page = $page; $query->where = $where; $this->data['list_items'] = $query->find(); //debug($this->data['items']); $this->data['pageBar'] = $query->getPageBar('/message/notify_filter/'); $this->setRenderData($this->data); $this->redirect('notify_filter'); }
echo IUrl::creatUrl("/goods/goods_del/id/{$item['id']}"); ?> '})" ><img class="operator" src="<?php echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/admin/icon_del.gif"; ?> " alt="删除" /></a></td> </tr> <?php } ?> </tbody> </table> </div> </form> <?php echo $goods_list->getPageBar(); ?> <script type="text/javascript"> //排序 function toSort(id) { if(id!='') { var va = $('#s'+id).val(); var part = /^\d+$/i; if(va!='' && va!=undefined && part.test(va)) { $.get("<?php echo IUrl::creatUrl("/goods/goods_sort"); ?> ",{'id':id,'sort':va}, function(data)
function refer_ajax() { $goods_id = IFilter::act(IReq::get('goods_id'), 'int'); $page = IFilter::act(IReq::get('page'), 'int') ? IReq::get('page') : 1; $referDB = new IQuery('refer as r'); $referDB->join = 'left join user as u on r.user_id = u.id'; $referDB->where = 'r.goods_id = ' . $goods_id; $referDB->order = 'r.id desc'; $referDB->fields = 'u.username,u.head_ico,r.time,r.question,r.reply_time,r.answer'; $referDB->page = $page; $data = $referDB->find(); $pageHtml = $referDB->getPageBar("javascript:void(0);", 'onclick="refer_ajax([page])"'); echo JSON::encode(array('data' => $data, 'pageHtml' => $pageHtml)); }
<a href="<?php echo IUrl::creatUrl("/seller/order_show/id/" . $item['id'] . ""); ?> "><img title="订单详情" alt="订单详情" src="<?php echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/main/icn_settings.png"; ?> " /></a> </td> </tr> <?php } ?> </tbody> </table> <?php echo $orderObject->getPageBar(); ?> </article> <script type="text/html" id="orderTemplate"> <form action="<?php echo IUrl::creatUrl("/"); ?> " method="get" name="filterForm"> <input type='hidden' name='controller' value='seller' /> <input type='hidden' name='action' value='order_list' /> <div class="module_content"> <fieldset> <label>订单号</label> <input name="search[order_no=]" value="" type="text" />
<a href="<?php echo IUrl::creatUrl("/seller/refer_edit/id/" . $item['id'] . ""); ?> "><img src="<?php echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/main/icn_audio.png"; ?> " title="回复咨询" /></a> <a href="javascript:delModel({link:'<?php echo IUrl::creatUrl("/seller/refer_del/id/" . $item['id'] . ""); ?> '})"><img src="<?php echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/main/icn_del.png"; ?> " title="删除" /></a> </td> </tr> <?php } ?> </tbody> </table> </form> <?php echo $referObj->getPageBar(); ?> </article> </section> <!--主题内容 结束--> </body> </html>
echo IUrl::creatUrl("/seller/goods_del/id/" . $item['id'] . ""); ?> '})"><img src="<?php echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/main/icn_del.png"; ?> " title="删除" /></a> </td> </tr> <?php } ?> </tbody> </table> </form> <?php echo $goodsObject->getPageBar(); ?> </article> <script type="text/html" id="filterTemplate"> <form action="<?php echo IUrl::creatUrl("/"); ?> " method="get" name="filterForm"> <input type='hidden' name='controller' value='seller' /> <input type='hidden' name='action' value='goods_list' /> <div class="module_content"> <fieldset> <label>商品名称</label> <input name="search[go.name=]" value="" type="text" />
?> '})" ><img class="operator" src="<?php echo IUrl::creatUrl("") . "views/" . $this->theme . "/skin/" . $this->skin . "/images/admin/icon_del.gif"; ?> " alt="删除" /></a> </td> </tr> <?php } ?> </tbody> </table> </div> </form> <?php echo $goodsHandle->getPageBar(); ?> <script type="text/javascript"> function goods_recycle_del() { $("form[name='orderForm']").attr('action','<?php echo IUrl::creatUrl("/goods/goods_recycle_del"); ?> '); confirm('确定要彻底删除所选中的信息吗?','formSubmit(\'orderForm\')'); } function goods_recycle_restore() { var flag = 0;