public function setStartCode() { $query = 'SELECT TOP 1 MemberCardNo FROM POS_Member WHERE MemberCardNo LIKE \'T%\' ORDER BY Code DESC'; $res = Processor::execErp($query); $member = odbc_fetch_array($res); $this->code = getArrayVal($member, 'MemberCardNo'); return $this; }
public function copy(array $codes) { foreach ($codes as $code) { $lastSerNo = array_get(Processor::getArrayResult($this->genFetchLastSerNoQuery()), '0.SerNo'); $row = Processor::getArrayResult($this->genSelectQuery([$code])); Processor::execErp($this->genInsertQuery($row[0], $lastSerNo)); } return $this; }
/** * 轉將指定的PIS_Goods(by Code),轉換為贈品 * * @param array $codes [PIS_Goods 的 code 集合陣列] * @param int $beforeDays [幾天之內的天數] * @return array $map ["originCode" => 'newCode'] */ public function convertToCGoods(array $codes, $beforeDays) { $map = []; foreach ($codes as $code) { Processor::execErp($this->getConvertyQuery($newCCode = $this->getNewCCode(), $code)); $map[$code] = $newCCode; } return $map; }
public static function fetchMightExistMembers($result) { $mightExistMembers = []; $nameQuery = self::getNameQuery(self::getNameList($result)); if ($res = Processor::execErp($nameQuery)) { while ($mightExistMembers[] = odbc_fetch_array($res)) { } } return $mightExistMembers; }
protected static function getBasicSheetCallback($columnFormatArray, $borderRange, $query, $headArray) { return function ($sheet) use($columnFormatArray, $borderRange, $query, $headArray) { $sheet->setAutoSize(true)->setFontFamily(ExportExcel::FONT_DEFAULT)->setFontSize(12)->setColumnFormat($columnFormatArray)->freezeFirstRow(); $sheet->cells('A1:' . $borderRange . '1', function ($cells) { $cells->setBackground('#000000')->setFontColor('#ffffff')->setAlignment('center'); }); if ($res = Processor::execErp($query)) { $i = 0; $sheet->row(++$i, $headArray); while ($row = odbc_fetch_array($res)) { c8res($row); $sheet->row(++$i, $row); } } }; }
public function index() { $startTime = microtime(true); $i = 0; $codeIndexArray = $this->convertToCodeIndexArray(); $res = Processor::execErp($this->genFetchQuery()); while ($member = odbc_fetch_array($res)) { $cityAndStateArr = $this->getArrayVal($codeIndexArray, $member['HomeAddress_ZipCode'], ['city' => '', 'state' => '']); $member['HomeAddress'] = $cityAndStateArr['state'] . '$' . $cityAndStateArr['city'] . '$' . $this->c8($member['HomeAddress_Address']); $member['HomeAddress_Address'] = $this->c8($member['HomeAddress_Address']); $member['HomeAddress_City'] = $cityAndStateArr['city']; $member['HomeAddress_State'] = $cityAndStateArr['state']; $i++; } $endTime = microtime(true); $exectime = floor($endTime - $startTime); return view('basic.simple', ['title' => '會員地址修正', 'des' => '修正台北縣,空白的縣市和區,統一地址格式', 'res' => '共修正了' . $i . '筆,耗時' . $exectime . '秒']); }
/** * genUpdateCCSOrderIndexQuerysByIterateOrderNos * * @param array $orders * @return array */ public function genUpdateCCSOrderIndexQuerysByIterateOrderNosAndExecute(array &$orderNoTrees) { foreach ($orderNoTrees as $orderNoTree) { $orderNo = $orderNoTree->getFirstName(); $newOrderNo = $this->getNewInsertCTOrderNo($this->getConvertOrderNo($orderNo)); Processor::execErp("UPDATE CCS_OrderIndex SET OrderNo='{$newOrderNo}' WHERE OrderNo='{$orderNo}'"); foreach ($orderNoTree->getChildren() as $child) { $newNo = $newOrderNo . $orderNoTree->fetchTailOfChild($child); Processor::execErp("UPDATE CCS_OrderDivIndex SET No='{$newNo}' WHERE No='{$child}'"); } $orderNoTree->setFirstName($newOrderNo); } return $this; }
public function updateProc(PosMemberImportContent $content) { Processor::execErp($this->getUpdateProcQuery($content)); return $this->memberflagUpdateProc($content)->contentUpdateProc($content); }
public function backmail() { set_time_limit(0); $startTime = microtime(true); $chunkSize = 200; $r = explode(',', file_get_contents(__DIR__ . '/backemail.txt')); $realGetCountTotal = 0; $totalNum = count($r); for ($i = 0; $i < $totalNum; $i = $i + $chunkSize) { $partialArr = array_slice($r, $i, $chunkSize); $data = Processor::getArrayResult($this->getQuery($partialArr)); $realGetCount = count($data); echo "{$i}:realGet:{$realGetCount}<br/>"; Processor::execErp($this->getUpdateQuery(array_pluck($data, 'SerNo'))); $realGetCountTotal += $realGetCount; } $endTime = microtime(true); dd("費時:" . floor($endTime - $startTime) . ",共計{$realGetCountTotal}人"); }