protected function getInsertProcQuery(PosMemberImportContent $content) { $sql = "exec dbo.sp_InsertHBMember "; $sql .= "{$this->getWrapVal($content->serno)}"; $sql .= ", {$this->getWrapVal($content->code)}"; $sql .= ", {$this->getWrapVal($content->sernoi)}"; $sql .= ",{$this->getWrapVal($content->name)},"; $sql .= "'" . Import::FEMALE_SEX_TEXT . "'" === $this->getWrapVal($content->sex) ? '0' : '1'; $sql .= ",{$this->getWrapVal($content->birthday)}"; $sql .= ",{$this->getWrapVal($content->hometel)}"; $sql .= ",{$this->getWrapVal($content->officetel)}"; $sql .= ",{$this->getWrapVal($content->cellphone)}"; $sql .= ",{$this->getWrapVal($content->email)}"; $sql .= ",{$this->getWrapVal($content->getZipcode())}"; $sql .= ",{$this->getWrapVal($content->getCityName())}"; $sql .= ",{$this->getWrapVal($content->getStateName())}"; $sql .= ",{$this->getWrapVal($content->homeaddress)}"; $sql .= ",{$this->getWrapVal($content->category)}"; $sql .= ",{$this->getWrapVal($content->salepoint_serno)}"; $sql .= ",{$this->getWrapVal($content->employee_serno)}"; $sql .= ",{$this->getWrapVal($content->exploit_serno)}"; $sql .= ",{$this->getWrapVal($content->exploit_emp_serno)}"; $sql .= ",{$this->getWrapVal($content->distinction)}"; $sql .= ",{$this->getWrapVal($content->member_level_ec)}"; $sql .= ",{$this->getWrapVal($content->employ_code)}"; $sql .= ",{$this->getWrapVal($content->memo)}"; return $sql; }
protected function getRowDataFromContent(PosMemberImportContent $content) { $row = [$content->serno, $content->code, $content->pos_member_import_task->category, $content->pos_member_import_task->distinction, $content->name, $content->birthday, $content->getZipcode(), $content->getCityName(), $content->getStateName(), $content->homeaddress, $content->cellphone, $content->hometel, $content->officetel, $content->email, $content->period_at, $content->hospital, $content->memo]; return array_merge($row, array_values($this->getContentFlags($content))); }