keyword = $keyword2;
$this->state = I('request.state','');
$condition = "";
if (!empty($keyword)) {
$condition .= " and (room_address like '%".$keyword."%' or room_name like '%".$keyword."%' or mobile like '%".$keyword."%') ";
}
if(!empty($this->state)){
if($this->state == 2){
$condition .= " and state= 0 ";
}else{
$condition .= " and state= ".$this->state;
}
}
$supply_id = 0;
if (defined('ROLE') && ROLE == 'agenter' )
{
$supper_info = get_agent_logininfo();
$supply_id = $supper_info['id'];
$condition .= " and supply_id= ".$supply_id;
}
$list = M()->query('SELECT * FROM '. C('DB_PREFIX'). "lionfish_comshop_salesroom WHERE 1=1 "
. $condition . ' order by displayorder desc, id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize);
foreach ($list as $k=>$v) {
if(empty($v['supply_id'])){
$list[$k]['supply_name'] = "平台";
}else{
$supply_info = M('lionfish_comshop_supply')->where( array('id' => $v['supply_id']) )->field('shopname')->find();
$list[$k]['supply_name'] = $supply_info['shopname'];
}
$list[$k]['member_count'] = M('lionfish_comshop_salesroom_relative_member')->where( array('salesroom_id' => $v['id']) )->count();
$list[$k]['disable_time'] = date('Y-m-d H:i:s',$v['disable_time']);
}
$total = M('lionfish_comshop_salesroom')->where("1=1 ".$condition)->count();
$pager = pagination2($total, $pindex, $psize);
$this->list = $list;
$this->pager = $pager;
$this->display();
}
/**
* 编辑添加
*/
public function add()
{
$id = I('request.id');
if (!empty($id)) {
$item = M('lionfish_comshop_salesroom')->where( array('id' => $id) )->find();
if(!empty($item['supply_id'])){
$item['supply_info'] = M('lionfish_comshop_supply')->where( array('id' => $item['supply_id']) )->find();
}
$this->id = $id;
$this->item = $item;
}
$supply_id = 0;
if (defined('ROLE') && ROLE == 'agenter' )
{
$supper_info = get_agent_logininfo();
$supply_id = $supper_info['id'];
}
$this->supply_id = $supply_id;
if (IS_POST) {
$data = I('request.data');
if($supply_id > 0){
$data['supply_id'] = $supply_id;
}
D('Seller/Salesroom')->update($data);
show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
}
$this->display('Salesroom/add');
}
/**
* 改变状态
*/
public function change()
{
$id = I('request.id');
//ids
if (empty($id)) {
$ids = I('request.ids');
$id = ((is_array($ids) ? implode(',', $ids) : 0));
}
if (empty($id)) {
show_json(0, array('message' => '参数错误'));
}
$type = I('request.type');
$value = I('request.value');
if (!(in_array($type, array('state')))) {
show_json(0, array('message' => '参数错误'));
}
$items = M('lionfish_comshop_salesroom')->where( array('id' => array('in', $id) ) )->select();
foreach ($items as $item) {
if($value == 0){
M('lionfish_comshop_salesroom')->where( array('id' => $item['id']) )->save( array($type => $value,'disable_time'=>time()) );
D('Seller/Salesroom')->update_hxgoods($item['id']);
}else{
M('lionfish_comshop_salesroom')->where( array('id' => $item['id']) )->save( array($type => $value) );
}
}
show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
}
/**
* 删除
*/
public function delete()
{
$id = I('request.id');
if (empty($id)) {
$ids = I('request.ids');
$id = (is_array($ids) ? implode(',', $ids) : 0);
}
$items = M('lionfish_comshop_salesroom')->field('id,room_name')->where( array('id' => array('in', $id) ) )->select();
if (empty($item)) {
$item = array();
}
foreach ($items as $item) {
M('lionfish_comshop_salesroom')->where( array('id' => $item['id']) )->delete();
D('Seller/Salesroom')->update_hxgoods($item['id']);
}
show_json(1, array('url' => $_SERVER['HTTP_REFERER']));
}
public function query(){
$_GPC = I('request.');
$kwd = I('request.keyword','');
$condition = ' 1 ';
if (!empty($kwd)) {
$condition .= ' AND ( `room_name` LIKE '.'"%' . $kwd . '%"'.' or `mobile` LIKE '.'"%' . $kwd . '%"'.' or `room_address` LIKE '.'"%' . $kwd . '%"'.' )';
}
$supply_id = I('request.supply_id', 0);
if (defined('ROLE') && ROLE == 'agenter' )
{
$supper_info = get_agent_logininfo();
$supply_id = $supper_info['id'];
$condition.= ' AND supply_id='.$supply_id;
}else{
if(empty($supply_id)){
$supply_id = 0;
}
$condition.= ' AND supply_id='.$supply_id;
}
$condition.=' AND state=1 ';
$ds = M('lionfish_comshop_salesroom')->where( $condition )->field('id,room_name,room_logo,supply_id,room_address,mobile')->select();
$s_html = "";
foreach ($ds as &$value) {
if(empty($value['supply_id'])){
$value['supply_name'] = "平台";
}else{
$supply_info = M('lionfish_comshop_supply')->where( array('id' => $value['supply_id']) )->field('shopname')->find();
$value['supply_name'] = $supply_info['shopname'];
}
$value['room_name'] = htmlspecialchars($value['room_name'], ENT_QUOTES);
$value['room_logo'] = tomedia($value['room_logo']);
$s_html .= "![](".$value[) {$value[room_name]} | ";
$s_html .= "{$value['room_address']} | ";
$s_html .= "{$value['supply_name']} | ";
$s_html .= "{$value['mobile']} | ";
if( isset($_GPC['template']) && $_GPC['template'] == 'mult'){
$s_html .= '选择 |
';
}else if( isset($_GPC['template']) && $_GPC['template'] == 'mult_goods'){
$s_html .= '选择 | ';
}else{
$s_html .= '选择 | ';
}
}
unset($value);
if( isset($_GPC['is_ajax']) && $_GPC['is_ajax'] == 1)
{
echo json_encode( array('code' =>0, 'html' => $s_html) );
die();
}
$url = 'salesroom/query';
$this->url = $url;
$this->ds = $ds;
$this->gpc = $_GPC;
$this->kwd = $kwd;
$this->supply_id = $supply_id;
$this->display();
}
}
?>