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;
}
