{"id":199379,"date":"2025-05-03T11:39:06","date_gmt":"2025-05-03T03:39:06","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199379\/"},"modified":"2025-05-03T11:39:06","modified_gmt":"2025-05-03T03:39:06","slug":"ecshop%e6%b7%bb%e5%8a%a0%e7%89%a9%e6%96%99%e5%ba%93%e5%ad%98%e7%ae%a1%e7%90%86%e5%8a%9f%e8%83%bd","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199379\/","title":{"rendered":"ecshop\u6dfb\u52a0\u7269\u6599\u5e93\u5b58\u7ba1\u7406\u529f\u80fd"},"content":{"rendered":"

1\u3001\u521b\u5efa\u7269\u6d41\u5e93\u5b58\u8868\u3002sql\u8bed\u53e5\uff1a<\/p>\n

CREATE TABLE IF NOT EXISTS `emws_materials` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
`modulus` varchar(60) NOT NULL,
`stock_number` smallint(5) unsigned NOT NULL default ‘0’,
`stock_in` smallint(5) unsigned NOT NULL default ‘0’,
`stock_out` smallint(5) unsigned NOT NULL default ‘0’,
`safe_day` smallint(5) unsigned NOT NULL default ‘0’,
`intent_day` smallint(5) unsigned NOT NULL default ‘0’,
`is_buy` tinyint(1) unsigned NOT NULL default ‘1’,
`buy_url` varchar(60) NOT NULL,
`price` decimal(10,2) NOT NULL,
`weight` smallint(5) unsigned NOT NULL default ‘0’,
`img` varchar(60) NOT NULL,
`desc_info` varchar(60) NOT NULL,
`remark` varchar(60) NOT NULL,
`admin_id` smallint(5) unsigned NOT NULL,
`update_time` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8<\/p>\n

2\u3001php\u7a0b\u5e8f\uff0cmaterials.php\uff1a<\/p>\n

<?php define(‘IN_ECS’, true); require(dirname(__FILE__) . ‘\/includes\/init.php’); include_once(ROOT_PATH . ‘includes\/cls_image.php’); $image = new cls_image($_CFG[‘bgcolor’]); $exc = new exchange($ecs->table(“materials”), $db, ‘id’, ‘name’); $_REQUEST[‘act’]=!empty($_REQUEST[‘act’]) ? $_REQUEST[‘act’]:’list’; admin_priv(‘stock_alert’);\/\/\u6743\u9650\uff1a\u5e93\u5b58\u6570\u91cf\u4fee\u6539 if($_REQUEST[‘act’] == ‘list’) {     $stock_list=material_list();     $smarty->assign(‘ur_here’,      ‘\u7269\u6599\u5e93\u5b58\u5217\u8868’);     $smarty->assign(‘stock_list’,     $stock_list[‘stock_list’]);     $smarty->assign(‘filter’,       $stock_list[‘filter’]);     $smarty->assign(‘record_count’, $stock_list[‘record_count’]);     $smarty->assign(‘page_count’,   $stock_list[‘page_count’]);          $smarty->assign(‘shelf_list’,     $shelf_list);     $smarty->assign(‘full_page’,    1);     $smarty->assign(‘action_link’,  array(‘href’ => ‘goods_stock.php?act=list’, ‘text’ => ‘\u5546\u54c1\u5e93\u5b58\u5217\u8868’));     $smarty->assign(‘action_link2’,  array(‘href’ => ‘materials.php?act=export’, ‘text’ => ‘\u5bfc\u51fa\u91c7\u8d2d\u5355’));     $smarty->assign(‘action_link3’,  array(‘href’ => ‘materials.php?act=add’, ‘text’ => ‘\u6dfb\u52a0\u7269\u6599’));          $smarty->display(‘material_list.htm’); } elseif($_REQUEST[‘act’] == ‘add’) {         $smarty->assign(‘ur_here’,      “\u6dfb\u52a0\u7269\u6599”);     $smarty->assign(‘action_link’, array(‘href’ => ‘materials.php?act=list’, ‘text’ => ‘\u8fd4\u56de\u7269\u6599\u5e93\u5b58\u5217\u8868’));     $smarty->assign(‘form_action’, “insert”);       assign_query_info();     $smarty->display(‘material_info.htm’); } elseif($_REQUEST[‘act’] == ‘insert’) {     $material[‘is_buy’]    = isset($_REQUEST[‘is_buy’]) ? intval($_REQUEST[‘is_buy’]) : 1;     $material[‘name’]      = isset($_REQUEST[‘name’]) ? trim($_REQUEST[‘name’]) : ”;     $material[‘modulus’]   = isset($_REQUEST[‘modulus’]) ? trim($_REQUEST[‘modulus’]) : ”;     $material[‘safe_day’]  = isset($_REQUEST[‘safe_day’]) ? intval($_REQUEST[‘safe_day’]) : 0;     $material[‘intent_day’]= isset($_REQUEST[‘intent_day’]) ? intval($_REQUEST[‘intent_day’]) : 0;     $material[‘price’]     = isset($_REQUEST[‘price’]) ? floatval($_REQUEST[‘price’]) : ‘0.00’;     $material[‘weight’]    = isset($_REQUEST[‘weight’]) ? intval($_REQUEST[‘weight’]) : 0;     $material[‘desc_info’] = isset($_REQUEST[‘desc_info’]) ? trim($_REQUEST[‘desc_info’]) : ”;     $material[‘remark’]    = isset($_REQUEST[‘remark’]) ? trim($_REQUEST[‘remark’]) : ”;     $material[‘update_time’]= gmtime();     $material[‘admin_id’]   = $_SESSION[‘admin_id’];          if(empty($material[‘name’]) || empty($material[‘modulus’]) || empty($material[‘safe_day’]) || empty($material[‘intent_day’]))     {         sys_msg(‘\u540d\u79f0\u3001\u7cfb\u6570\u3001\u5b89\u5168\u5929\u6570\u3001\u76ee\u6807\u5929\u6570\uff0c\u4e0d\u80fd\u4e3a\u7a7a\u6216\u8005\u683c\u5f0f\u4e0d\u6b63\u786e’, 1);     }          $is_only = $exc->is_only(‘name’, $material[‘name’]);     if (!$is_only)     {         sys_msg($material[‘name’].’\uff0c\u5df2\u5b58\u5728’, 1);     }        \/*\u5904\u7406\u56fe\u7247*\/     $material[‘img’] = basename($image->upload_image($_FILES[‘img’],’material’));      \/*\u5904\u7406URL*\/     $material[‘buy_url’] = sanitize_url($_POST[‘buy_url’]);     \/*\u63d2\u5165\u6570\u636e*\/     $db->autoExecute($ecs->table(‘materials’), $material, ‘INSERT’, ”, ‘SILENT’);       $link[0][‘text’] = ‘\u7ee7\u7eed\u6dfb\u52a0’;     $link[0][‘href’] = ‘materials.php?act=add’;     $link[1][‘text’] = ‘\u8fd4\u56de\u5217\u8868’;     $link[1][‘href’] = ‘materials.php?act=list’;     sys_msg(‘\u6dfb\u52a0\u6210\u529f’, 0, $link); } elseif($_REQUEST[‘act’] == ‘updata’) {     $id    = isset($_REQUEST[‘id’]) ? intval($_REQUEST[‘id’]) : 0;     $material[‘is_buy’]    = isset($_REQUEST[‘is_buy’]) ? intval($_REQUEST[‘is_buy’]) : 1;     $material[‘name’]      = isset($_REQUEST[‘name’]) ? trim($_REQUEST[‘name’]) : ”;     $material[‘modulus’]   = isset($_REQUEST[‘modulus’]) ? trim($_REQUEST[‘modulus’]) : ”;     $material[‘safe_day’]  = isset($_REQUEST[‘safe_day’]) ? intval($_REQUEST[‘safe_day’]) : 0;     $material[‘intent_day’]= isset($_REQUEST[‘intent_day’]) ? intval($_REQUEST[‘intent_day’]) : 0;     $material[‘price’]     = isset($_REQUEST[‘price’]) ? floatval($_REQUEST[‘price’]) : ‘0.00’;     $material[‘weight’]    = isset($_REQUEST[‘weight’]) ? intval($_REQUEST[‘weight’]) : 0;     $material[‘desc_info’] = isset($_REQUEST[‘desc_info’]) ? trim($_REQUEST[‘desc_info’]) : ”;     $material[‘remark’]    = isset($_REQUEST[‘remark’]) ? trim($_REQUEST[‘remark’]) : ”;     $material[‘update_time’]= gmtime();     $material[‘admin_id’]   = $_SESSION[‘admin_id’];          if(empty($id))     {         sys_msg(‘ID\u4e0d\u80fd\u4e3a\u7a7a’, 1);     }          if(empty($material[‘name’]) || empty($material[‘modulus’]) || empty($material[‘safe_day’]) || empty($material[‘intent_day’]))     {         sys_msg(‘\u540d\u79f0\u3001\u7cfb\u6570\u3001\u5b89\u5168\u5929\u6570\u3001\u76ee\u6807\u5929\u6570\uff0c\u4e0d\u80fd\u4e3a\u7a7a\u6216\u8005\u683c\u5f0f\u4e0d\u6b63\u786e’, 1);     }        \/*\u5904\u7406\u56fe\u7247*\/      if(!empty($_FILES[‘img’][‘name’]))      {         $material[‘img’] = basename($image->upload_image($_FILES[‘img’],’material’));      }      \/*\u5904\u7406URL*\/     $material[‘buy_url’] = sanitize_url($_POST[‘buy_url’]);     \/*\u63d2\u5165\u6570\u636e*\/     $db->autoExecute($ecs->table(‘materials’), $material, ‘UPDATE’, “id = ‘$id'”);       $link[0][‘text’] = ‘\u7ee7\u7eed\u7f16\u8f91’;     $link[0][‘href’] = ‘materials.php?act=edit&id=’.$id;     $link[1][‘text’] = ‘\u8fd4\u56de\u5217\u8868’;     $link[1][‘href’] = ‘materials.php?act=list’;     sys_msg(‘\u7f16\u8f91\u6210\u529f’, 0, $link); } elseif ($_REQUEST[‘act’] ==’edit’) {     $sql = “SELECT * FROM ” .$ecs->table(‘materials’). ” WHERE id=’$_REQUEST[id]'”;     $material = $db->GetRow($sql);     $smarty->assign(‘ur_here’,     “\u7f16\u8f91\u7269\u6599”);     $smarty->assign(‘action_link’, array(‘href’ => ‘materials.php?act=list’, ‘text’ => ‘\u8fd4\u56de\u7269\u6599\u5e93\u5b58\u5217\u8868’));     $smarty->assign(‘material’,    $material);     $smarty->assign(‘form_action’, ‘updata’);     assign_query_info();     $smarty->display(‘material_info.htm’); } elseif ($_REQUEST[‘act’] == ‘remove’) {     $id = intval($_GET[‘id’]);     $exc->drop($id);     $url = ‘materials.php?act=query&’ . str_replace(‘act=remove’, ”, $_SERVER[‘QUERY_STRING’]);     ecs_header(“Location: $url\\n”);     exit; } elseif ($_REQUEST[‘act’] == ‘drop_img’) {     $id = isset($_GET[‘id’]) ? intval($_GET[‘id’]) : 0;       $sql = “SELECT img FROM ” .$ecs->table(‘materials’). ” WHERE id = ‘$id'”;     $img_name = $db->getOne($sql);       if (!empty($img_name))     {         @unlink(ROOT_PATH . DATA_DIR . ‘\/material\/’ .$img_name);         $sql = “UPDATE ” .$ecs->table(‘materials’). ” SET img = ” WHERE id = ‘$id'”;         $db->query($sql);     }     $link= array(array(‘text’ => ‘\u7ee7\u7eed\u7f16\u8f91’, ‘href’ => ‘materials.php?act=edit&id=’ . $id), array(‘text’ => ‘\u8fd4\u56de\u7269\u6599\u5e93\u5b58\u5217\u8868’, ‘href’ => ‘materials.php?act=list’));     sys_msg(‘\u56fe\u7247\u5220\u9664\u6210\u529f’, 0, $link); }     elseif ($_REQUEST[‘act’] == ‘edit_stock_in’) \/\/\u66f4\u6539\u5165\u5e93 {     $id = intval($_POST[‘id’]);     $val = json_str_iconv(trim($_POST[‘val’]));     \/* \u68c0\u67e5\u683c\u5f0f *\/     if(!is_numeric($val) || $val < 0)     {         make_json_error(sprintf(“\u683c\u5f0f\u4e0d\u6b63\u786e\uff01”,  $val));     }          $exc->edit(“stock_in=’$val'”, $id);     make_json_result(stripslashes($val)); } elseif ($_REQUEST[‘act’] == ‘edit_stock_out’) \/\/\u66f4\u6539\u51fa\u5e93 {     $id = intval($_POST[‘id’]);     $val = json_str_iconv(trim($_POST[‘val’]));     \/* \u68c0\u67e5\u683c\u5f0f *\/     if(!is_numeric($val) || $val < 0)     {         make_json_error(sprintf(“\u683c\u5f0f\u4e0d\u6b63\u786e\uff01”,  $val));     }     $sql=”SELECT * FROM “.$GLOBALS[‘ecs’]->table(‘materials’).” where id = ‘”.$id.”‘”;     $material = $GLOBALS[‘db’]->getRow($sql);      if($val > $material[‘stock_in’] + $material[‘stock_number’])     {         make_json_error(sprintf(“\u51fa\u5e93\u6570\u4e0d\u80fd\u5927\u4e8e\u73b0\u6709\u5e93\u5b58\u4e0e\u5165\u5e93\u603b\u548c\uff01”,  $val));     }          $exc->edit(“stock_out=’$val'”, $id);     make_json_result(stripslashes($val)); } elseif ($_REQUEST[‘act’] == ‘operate’) \/\/\u6279\u91cf\u5165\u5e93\/\u51fa\u5e93 {     $sql = “UPDATE ” .$ecs->table(‘materials’). ” SET stock_number = stock_number + stock_in – stock_out,stock_out = 0,stock_in = 0,admin_id=$_SESSION[admin_id],update_time = “.gmtime();     $db->query($sql);     $link= array(array(‘text’ => ‘\u8fd4\u56de\u7269\u6599\u5e93\u5b58\u5217\u8868’, ‘href’ => ‘materials.php?act=list’));     sys_msg(‘\u6210\u529f\u6279\u91cf\u5165\u5e93\/\u51fa\u5e93’, 0, $link); } elseif ($_REQUEST[‘act’] == ‘export’) \/\/\u5bfc\u51fa\u91c7\u8d2d\u5355 {     include_once(‘includes\/PHPExcel\/PHPExcel.php’);     include_once(‘corlor.php’);     $objPHPExcel = new PHPExcel();       $filename = ‘\u7269\u6599\u91c7\u8d2d\u8868_’.date(“YmdHi”,gmtime());     $objPHPExcel->setActiveSheetIndex(0);     $objPHPExcel->getActiveSheet()->setTitle($filename);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘A’)->setWidth(15);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘B’)->setWidth(15);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘C’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘D’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘E’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘F’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘G’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘H’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘I’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘J’)->setWidth(10);     $objPHPExcel->getActiveSheet()->getStyle(‘C1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getStyle(‘D1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getStyle(‘F1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getStyle(‘G1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getStyle(‘H1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getStyle(‘I1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getStyle(‘J1’)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);     $objPHPExcel->getActiveSheet()->getColumnDimension(‘K’)->setWidth(10);     $objPHPExcel->setActiveSheetIndex(0)     ->setCellValue(‘A1’, ‘\u7269\u6599\u540d\u79f0’)     ->setCellValue(‘B1’, ‘\u56fe\u7247’)         ->setCellValue(‘C1’, ‘\u6bcf\u5929\u7528\u91cf’)     ->setCellValue(‘D1’, ‘\u73b0\u6709\u5e93\u5b58’)     ->setCellValue(‘E1’, ‘\u5468\u8f6c\u5929\u6570’)     ->setCellValue(‘F1’, ‘\u5b89\u5168\u5e93\u5b58’)     ->setCellValue(‘G1’, ‘\u76ee\u6807\u5e93\u5b58’)     ->setCellValue(‘H1’, ‘\u5efa\u8bae\u8d2d\u4e70’)     ->setCellValue(‘I1’, ‘\u5355\u4ef7’)     ->setCellValue(‘J1’, ‘\u5b9e\u9645\u5355\u4ef7’)     ->setCellValue(‘K1’, ‘\u91c7\u8d2d\u94fe\u63a5’);     $i=2;     $stock_list = material_list(false);     $arr = $stock_list[‘stock_list’];     foreach($arr as $v)     {         if($v[‘img’])         {             $objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(50);             $objDrawing = new PHPExcel_Worksheet_Drawing();             $objDrawing->setName(‘goods thumb’);             $objDrawing->setDescription(‘Pgoods thumb’);             $img_path = file_exists(‘..\/data\/material\/’.$v[‘img’]) ? ‘..\/data\/material\/’.$v[‘img’] : ‘..\/images\/no_img.jpg’;             $objDrawing->setPath($img_path);             $objDrawing->setWidth(100);             $objDrawing->setCoordinates(‘B’.$i);             $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());         }         else         {             $objPHPExcel->setActiveSheetIndex(0)->setCellValue(‘B’.$i, ”);             }           $objPHPExcel->setActiveSheetIndex(0)             ->setCellValue(‘A’.$i, $v[‘name’])             ->setCellValue(‘C’.$i, $v[‘day_use’])             ->setCellValue(‘D’.$i, $v[‘stock_number’])             ->setCellValue(‘E’.$i, $v[‘stock_day’])             ->setCellValue(‘F’.$i, $v[‘stock_safe’])             ->setCellValue(‘G’.$i, $v[‘stock_intent’])             ->setCellValue(‘H’.$i, $v[‘proposal_buy’])             ->setCellValue(‘I’.$i, $v[‘price’])             ->setCellValue(‘J’.$i, ”);         if($v[‘stock_safe’] >= $v[‘stock_number’])         {             $objPHPExcel->setActiveSheetIndex(0)->getStyle(‘D’.$i)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);         }         if($v[‘buy_url’] != ‘http:\/\/’)         {             $objPHPExcel->setActiveSheetIndex(0)->setCellValue(‘K’.$i, ‘\u91c7\u8d2d\u94fe\u63a5’);             $objPHPExcel->setActiveSheetIndex(0)->getCell(‘K’.$i)->getHyperlink()->setUrl($v[‘buy_url’]);             $objPHPExcel->setActiveSheetIndex(0)->getCell(‘K’.$i)->getHyperlink()->setTooltip(‘\u91c7\u8d2d\u94fe\u63a5’);             $objPHPExcel->setActiveSheetIndex(0)->getStyle(‘K’.$i)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE);             $objPHPExcel->setActiveSheetIndex(0)->getStyle(‘K’.$i)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);         }         else         {             $objPHPExcel->setActiveSheetIndex(0)->setCellValue(‘K’.$i, ”);         }         $objPHPExcel->getActiveSheet()->getStyle(‘A’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘B’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘C’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘D’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘E’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘F’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘G’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘H’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘I’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘J’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $objPHPExcel->getActiveSheet()->getStyle(‘K’.$i)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);         $i++;     }     $file_name    =    $filename.’.xls’;     header(‘Content-Type: application\/vnd.ms-excel’);     header(‘Content-Disposition: attachment;filename=”‘.$file_name.'”‘);     header(‘Cache-Control: max-age=0’);     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5’);     $objWriter->save(‘php:\/\/output’);     exit; } elseif ($_REQUEST[‘act’] == ‘query’) {         $stock_list = material_list();     $smarty->assign(‘stock_list’,     $stock_list[‘stock_list’]);     $smarty->assign(‘filter’,       $stock_list[‘filter’]);     $smarty->assign(‘record_count’, $stock_list[‘record_count’]);     $smarty->assign(‘page_count’,   $stock_list[‘page_count’]);     make_json_result($smarty->fetch(‘material_list.htm’), ”, array(‘filter’ => $stock_list[‘filter’], ‘page_count’ => $stock_list[‘page_count’])); }   function material_list($is_pagination = true) {     GLOBAL $ecs,$db;     $result = get_filter();     if ($result === false)     {         $filter[‘sort_by’] = empty($_REQUEST[‘sort_by’]) ? ‘id’ : trim($_REQUEST[‘sort_by’]);         $filter[‘sort_order’] = empty($_REQUEST[‘sort_order’]) ? ‘desc’ : trim($_REQUEST[‘sort_order’]);         $where = ” WHERE 1 = 1 “;           $sql = ‘select count(t.id) from ‘.$ecs->table(‘materials’). ‘ as t ‘.$where;                  $filter[‘record_count’] = $db->getOne($sql);                  \/* \u5206\u9875\u5927\u5c0f *\/         $filter = page_and_size($filter);                  $sql = ‘select t.*, au.user_name from ‘.                 $ecs->table(‘materials’).’ as t left join ‘.                 $ecs->table(‘admin_user’).” as au on t.admin_id=au.user_id “.$where.                 ‘ order by ‘.$filter[‘sort_by’].” “.$filter[‘sort_order’];                  if ($is_pagination)
\n\/\/www.ldhost.cn<\/span>         {             $sql .= ” LIMIT ” . $filter[‘start’] . ‘, ‘ . $filter[‘page_size’];         }                  $end_time   = strtotime(date(“Y-m-d”,gmtime()));         $start_time = $end_time – 7 * 86400;         $query = “SELECT count(order_id) as total FROM “.$GLOBALS[‘ecs’]->table(‘order_info’).” WHERE synch_time < ‘”.$end_time.”‘ and synch_time >= ‘”.$start_time.”‘”;         $filter[‘orders’] = round($GLOBALS[‘db’]->getOne($query) \/ 7);\/\/7\u5929\u5e73\u5747\u8ba2\u5355\u6570             $filter[‘orders’] = $filter[‘orders’] ? $filter[‘orders’] : 1400;          set_filter($filter, $sql);     }     else     { 
\n\/\/www.ldhost.cn<\/span>         $sql    = $result[‘sql’];         $filter = $result[‘filter’];     }     $row = $GLOBALS[‘db’]->getAll($sql);          $orders = $filter[‘orders’];     foreach($row as $k=>$val)     {         if ($is_pagination == false && $val[‘is_buy’] == 0) \/\/\u4e0d\u8d2d\u4e70\uff0c\u4e0d\u5bfc\u51fa         {             unset($row[$k]);             continue;         }         $row[$k][‘update_time’] = local_date(‘Y-m-d H:i’,$val[‘update_time’]);         $row[$k][‘day_use’]     = $day_use = round($orders * $val[‘modulus’],1);\/\/\u6bcf\u65e5\u7528\u91cf         $row[$k][‘stock_day’]   = $day_use ? round($val[‘stock_number’] \/ $day_use,1) : 0;\/\/\u5468\u8f6c\u5929\u6570         $row[$k][‘stock_safe’]  = round($val[‘safe_day’] * $day_use,1);\/\/\u5b89\u5168\u5e93\u5b58         $row[$k][‘stock_intent’]= $stock_intent = round($val[‘intent_day’] * $day_use,1);\/\/\u76ee\u6807\u5e93\u5b58         $row[$k][‘proposal_buy’]= round($stock_intent – $val[‘stock_number’],1);\/\/\u5efa\u8bae\u8d2d\u4e70     }          $stock_list = array(‘stock_list’ => $row, ‘filter’ => $filter, ‘page_count’ => $filter[‘page_count’], ‘record_count’ => $filter[‘record_count’]);     return $stock_list; } ?> <\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

1\u3001\u521b\u5efa\u7269\u6d41\u5e93\u5b58\u8868\u3002sql\u8bed\u53e5\uff1a...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199379","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199379"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199379\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}