protected function genInsertMemberInfoValue(&$mixInfo) { $this->initMixInfoEle($mixInfo, 'memberinfo', ExcelHelper::rmi('AP')); $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_SERNO_INDEX] = $mixInfo['code']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_CREATEDATE_INDEX] = date('Ymd'); $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_NAME_INDEX] = $mixInfo['name']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_SEX_INDEX] = '0'; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_BIRTHDAY_INDEX] = $mixInfo['birthday']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_CATEGORYCODE_INDEX] = HoneyBaby::MEMBER_CATEGORY_CODE; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_DISCODE_INDEX] = FixtureHelper::getDistincCode($this->getDateString()); $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_LEVEL_INDEX] = HoneyBaby::MEMBER_LEVEL_CODE; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_HOMETEL_INDEX] = $mixInfo['homeTel']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_COMPANYTEL_INDEX] = $mixInfo['companyTel']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_MOBILE_INDEX] = $mixInfo['mobile']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_AREACODE_PREV_INDEX] = substr($mixInfo['areacode'], 0, 3); $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_AREACODE_NEXT_INDEX] = false === ($codeTail2 = substr($mixInfo['areacode'], 3, 2)) ? '' : $codeTail2; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_ADDRESS_INDEX] = $mixInfo['state'] . $mixInfo['city'] . $mixInfo['address']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_EMAIL_INDEX] = $mixInfo['email']; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_EMPCODE_INDEX] = HoneyBaby::MEMBER_EMP_CODE; $mixInfo['memberinfo'][HoneyBaby::EXPORT_INSERT_MEMBERINFO_MEMO_INDEX] = $mixInfo['newCustomMemo']; return $this; }
protected function getSpecificNav() { $arr = array_fill(0, 25, NULL); $arr[ExcelHelper::rmi('B')] = '本月業績'; $arr[ExcelHelper::rmi('I')] = '去年'; $arr[ExcelHelper::rmi('K')] = 'PL業績(含稅)'; $arr[ExcelHelper::rmi('Q')] = '毛利(含稅)'; $arr[ExcelHelper::rmi('T')] = '來客&客單'; return $arr; }