PHP CommonModel::getPurchaseList方法代码示例

 /**
  * CommonAct::actGetPurchaseList()
  * 获取公司采购列表
  * @param int $all 是否全部获取 true全部获取
  * @return  array
  */
 public static function actGetPurchaseList($all = false)
 {
     $cacheName = md5("purchase_list");
     $memc_obj = new Cache(C('CACHEGROUP'));
     $purchaseInfo = $memc_obj->get_extral($cacheName);
     if (!empty($purchaseInfo)) {
         $purchaseInfo = unserialize($purchaseInfo);
     } else {
         $purchaseInfo = CommonModel::getPurchaseList();
         $isok = $memc_obj->set_extral($cacheName, serialize($purchaseInfo));
         if (!$isok) {
             self::$errCode = 0;
             self::$errMsg = 'memcache缓存出错!';
             //return false;
         }
     }
     if ($all) {
         return $purchaseInfo;
         exit;
     }
     //获取当前用户可见采购帐号
     $res = CommonAct::actGetPurchaseAccess();
     if (empty($res['power_ids'])) {
         $uids = isset($_SESSION[C('USER_AUTH_SYS_ID')]) ? $_SESSION[C('USER_AUTH_SYS_ID')] : 0;
     } else {
         $uids = $res['power_ids'];
     }
     if (empty($uids)) {
         self::$errCode = 10001;
         self::$errMsg = '您还尚未登录!';
         return false;
     }
     //获取可见采购的帐号信息
     $uidArr = explode(",", $uids);
     $realArr = array();
     foreach ($uidArr as $v) {
         foreach ($purchaseInfo as $key => $val) {
             if ($val['userId'] == $v) {
                 array_push($realArr, array("userId" => $val['userId'], "userName" => $val['userName']));
                 break;
             }
         }
     }
     return $realArr;
 }

 public function view_showPackage()
 {
     $navlist = array(array('url' => '', 'title' => '库存管理'), array('url' => '', 'title' => '点货清单'));
     $toplevel = 0;
     $secondlevel = 03;
     $checkUser = isset($_GET['checkUser']) ? $_GET['checkUser'] : "";
     $purchase = isset($_GET['purchase']) ? $_GET['purchase'] : "";
     $sku = isset($_GET['sku']) ? $_GET['sku'] : "";
     $status = isset($_GET['status']) ? $_GET['status'] : 3;
     $start = isset($_GET['startdate']) ? $_GET['startdate'] : "";
     $end = isset($_GET['enddate']) ? $_GET['enddate'] : "";
     $this->smarty->assign('navlist', $navlist);
     $this->smarty->assign('toplevel', $toplevel);
     $this->smarty->assign('secondlevel', $secondlevel);
     if (empty($checkUser) && empty($purchase) && empty($sku) && empty($start) && empty($end) && $status == 200) {
         $where = "where is_delete=0";
     } else {
         if (!empty($checkUser)) {
             $where[] = "tallyUserId='{$checkUser}'";
             $this->smarty->assign("tallyUserId", $checkUser);
         }
         if (!empty($purchase)) {
             $where[] = "purchaseId='{$purchase}'";
             $this->smarty->assign("purchase", $purchase);
         }
         if (!empty($sku)) {
             $where[] = "sku = '{$sku}'";
             $this->smarty->assign("sku", $sku);
         }
         if ($status != 200) {
             $where[] = "entryStatus = '{$status}'";
             $this->smarty->assign("status", $status);
         }
         if (!empty($start) && !empty($end)) {
             $starttime = strtotime($start);
             $endtime = strtotime($end);
             $where[] = "(entryTime between {$starttime} and {$endtime})";
             $this->smarty->assign("start", $start);
             $this->smarty->assign("end", $end);
         } elseif (!empty($start) && empty($end)) {
             $starttime = strtotime($start);
             $where[] = "entryTime >{$starttime}";
             $this->smarty->assign("start", $start);
         } elseif (empty($start) && !empty($end)) {
             $endtime = strtotime($end);
             $where[] = "entryTime < {$endtime}";
             $this->smarty->assign("end", $end);
         }
         $where = implode(" AND ", $where);
         $where = " where is_delete=0 and " . $where;
     }
     $where = $where . ' order by id desc';
     $nums = packageCheckModel::getTotalNums($where);
     $pagesize = 50;
     //$nums = count($lists);
     $pager = new Page($nums, $pagesize);
     $lists = packageCheckModel::selectList($where . " " . $pager->limit);
     if ($nums > $pagesize) {
         //分页
         $pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
     } else {
         $pagestr = $pager->fpage(array(0, 2, 3));
     }
     $userList = packageCheckModel::selectUser();
     $usermodel = UserModel::getInstance();
     foreach ($lists as $key => $list) {
         //到货库存
         $sku_arrival = OmAvailableModel::getTNameList("wh_sku_location", "arrivalInventory", "where sku='{$list['sku']}'");
         $lists[$key]['arrivalInventory'] = $sku_arrival[0]['arrivalInventory'];
         //获取原始点货数量
         $before_num = OmAvailableModel::getTNameList("wh_tallying_adjustment", "beforeNum", "where tallyListId='{$list['id']}' order by id asc limit 1");
         $lists[$key]['before_num'] = empty($before_num) ? $list['num'] : $before_num[0]['beforeNum'];
     }
     //点货员
     $tallyUser = $usermodel->getGlobalUserLists('global_user_id,global_user_name', "where a.global_user_job=209", '', '');
     $this->smarty->assign('tallyUser', $tallyUser);
     //采购员
     $purchaseList = CommonModel::getPurchaseList();
     $this->smarty->assign('purchaseList', $purchaseList);
     /** 添加贴标时间、QC检测时间、上架时间 add by GARY(yym)**/
     $this->smarty->registerPlugin('function', 'getSkuTime', 'getSkuTime');
     //$this->smarty->registerPlugin('function','getSkuInputTime','getSkuInputTime');
     /** end**/
     $toptitle = '点货清单列表';
     //顶部链接
     $this->smarty->assign('toptitle', $toptitle);
     $this->smarty->assign('pagestr', $pagestr);
     $this->smarty->assign("lists", $lists);
     $this->smarty->display('packageCheckList1.htm');
 }