/**
* @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;
