\u30fb\/data\/class\/SC_CustomerList.php\u3000\uff08L122\u3042\u305f\u308a)<\/strong><\/p>\n \/\/\u6027\u5225 \uff08L360\u3042\u305f\u308a)<\/strong><\/p>\n \/\/ \u691c\u7d22\u7528SQL \uff08L395\u3042\u305f\u308a\uff09<\/strong><\/p>\n function getMailMagazineColumn($is_mobile= false) { $column =”dtb_customer.customer_id, \u30fb\/data\/class\/helper\/SC_Helper_DB.php\u3000(L366\u3042\u305f\u308a\uff09<\/strong><\/p>\n \/\/ \u4fa1\u683c\u306e\u767b\u9332 \u203b\u6700\u5f8c\u306e\u300c\uff5d\u300d\u3092\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u6ce8\u610f\uff01<\/strong><\/p>\n \u30fb\/data\/class\/helper\/SC_Helper_CSV.php(L53\u3042\u305f\u308a\uff09<\/strong> * \u30c7\u30d5\u30a9\u30eb\u30c8\u30b3\u30f3\u30b9\u30c8\u30e9\u30af\u30bf. $masterData = new SC_DB_MasterData_Ex(); \u30fb\/data\/class\/page\/admin\/customer\/SC_Page_Admin_Customer.php\u3000(L62\u3042\u305f\u308a\uff09<\/strong><\/p>\n $this->arrJob = $masterData->getMasterData(“mtb_job”); \uff08L154\u3042\u305f\u308a\uff09<\/strong><\/p>\n 25 => array(“sql” => “cast(create_date as date) AS create_date”, \u203b26 =>\uff65\uff65\uff65\u306e\u6700\u5f8c\u306b\u3001\u300c,<\/strong>\u300d\u304c\u5165\u3063\u3066\u3044\u307e\u3059\u3002\u304a\u898b\u9003\u3057\u7121\u304f\u3002 \/\/ \u691c\u7d22\u30ef\u30fc\u30c9\u306e\u5f15\u304d\u7d99\u304e \u30fb\/data\/class\/page\/admin\/customer\/SC_Page_Admin_Customer_Edit.php\uff08L58\u3042\u305f\u308a)<\/strong><\/p>\n function init() { $masterData = new SC_DB_MasterData_Ex(); \uff08L109\u3042\u305f\u308a\uff09<\/strong><\/p>\n array( “column” => “reminder”, “convert” => “n” ), \uff08L320\u3042\u305f\u308a\uff09<\/strong><\/p>\n $objErr->doFunc(array(“\u3054\u6027\u5225”, “sex”) ,array(“SELECT_CHECK”, “NUM_CHECK”)); \u30fb\/data\/class\/page\/admin\/mail\/SC_Page_Admin_Mail.php \uff08L57\u3042\u305f\u308a)<\/strong><\/p>\n $masterData = new SC_DB_MasterData_Ex(); \uff08L96\u3042\u305f\u308a)<\/strong><\/p>\n \/\/—- \u691c\u7d22\u9805\u76ee (L191\u3042\u305f\u308a\uff09<\/strong><\/p>\n \/\/ \u914d\u4fe1\u5f62\u5f0f \/\/ \u6027\u5225\u306e\u5909\u63db \/\/ \u4f1a\u54e1\u30e9\u30f3\u30af\u306e\u5909\u63db \/\/ \u8077\u696d\u306e\u5909\u63db \u3010\u30b9\u30c6\u30c3\u30d72\u3011 \u30fb\/data\/class\/SC_CustomerList.php\u3000\uff08L122\u3042\u305f\u308a) \/\/\u6027\u5225 if (!isset($this->arrSql[‘sex’])) $this […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[183],"tags":[],"_links":{"self":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/posts\/1301"}],"collection":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1301"}],"version-history":[{"count":0,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=\/wp\/v2\/posts\/1301\/revisions"}],"wp:attachment":[{"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bton.papalabs.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nif (!isset($this->arrSql[‘sex’])) $this->arrSql[‘sex’] = “”;
\nif ( is_array( $this->arrSql[‘sex’] ) ){
\n$arrSexVal = $this->setItemTerm( $this->arrSql[‘sex’] ,”sex” );
\nforeach ($arrSexVal as $data) {
\n$this->arrVal[] = $data;
\n}
\n}
\n
\n\/\/\u4f1a\u54e1\u30e9\u30f3\u30af
\nif (!isset($this->arrSql[‘customer_rank’])) $this->arrSql[‘customer_rank’] = “”;
\nif ( is_array( $this->arrSql[‘customer_rank’] ) ){
\n$arrCustomer_rankVal = $this->setItemTerm( $this->arrSql[‘customer_rank’] ,”customer_rank” );
\nforeach ($arrCustomer_rankVal as $data) {
\n$this->arrVal[] = $data;
\n}
\n}
\n<\/span>
\n\/\/\u8077\u696d<\/p><\/blockquote>\n
\nfunction getList() {
\n$this->select = “SELECT customer_id,name01,name02,kana01,kana02,sex,email,tel01,tel02,tel03,pref,status,customer_rank<\/span> FROM dtb_customer “;
\nreturn $this->getSql(0);
\n}<\/p><\/blockquote>\n
\nif($is_mobile == true) {
\n$email_column = “dtb_customer.email_mobile as email”;
\n} else {
\n$email_column = “dtb_customer.email”;
\n}<\/p>\n
\ndtb_customer.name01,
\ndtb_customer.name02,
\ndtb_customer.kana01,
\ndtb_customer.kana02,
\ndtb_customer.sex,
\n$email_column,
\ndtb_customer.tel01,
\ndtb_customer.tel02,
\ndtb_customer.tel03,
\ndtb_customer.pref,
\ndtb_customer.create_date,
\ndtb_customer.mailmaga_flg,
\ndtb_customer.customer_rank”; <\/span>
\nreturn $column;
\n}<\/p><\/blockquote>\n
\n$objCustomer = new SC_Customer();
\n$objQuery = new SC_Query();
\nif($objCustomer->isLoginSuccess()) {
\n$customer_rank = $objCustomer->getValue(‘customer_rank’);
\n$discount_rank = $objQuery->get(“mtb_customer_discount”, “name”, “rank=?”, array($customer_rank));
\nif ($discount_rank != “”) {
\nif ($arrData[‘price02’] != “”) {
\n$objCartSess->setProductValue($arrCart[‘id’], ‘price’, $arrData[‘price02’]*$discount_rank);
\n$objPage->arrProductsClass[$cnt][‘uniq_price’] = $arrData[‘price02’]*$discount_rank;
\n} else {
\n$objCartSess->setProductValue($arrCart[‘id’], ‘price’, $arrData[‘price01’]*$discount_rank);
\n$objPage->arrProductsClass[$cnt][‘uniq_price’] = $arrData[‘price01’]*$discount_rank;
\n}
\n}else{
\nif ($arrData[‘price02’] != “”) {
\n$objCartSess->setProductValue($arrCart[‘id’], ‘price’, $arrData[‘price02’]);
\n$objPage->arrProductsClass[$cnt][‘uniq_price’] = $arrData[‘price02’];
\n} else {
\n$objCartSess->setProductValue($arrCart[‘id’], ‘price’, $arrData[‘price01’]);
\n$objPage->arrProductsClass[$cnt][‘uniq_price’] = $arrData[‘price01’];
\n}
\n}
\n<\/span>}<\/span><\/p><\/blockquote>\n
\n\u203b\u3053\u308c\u306f\u3001\u3082\u3057\u304b\u3057\u305f\u3089\u4e0d\u8981\u304b\u3082\u3002\u3002\u3002<\/p>\n
\n*\/
\nfunction SC_Helper_CSV() {
\n$this->init();<\/p>\n
\n$this->arrPref = $masterData->getMasterData(“mtb_pref”,
\narray(“pref_id”, “pref_name”, “rank”));
\n$this->arrSex = $masterData->getMasterData(“mtb_sex”);
\n$this->arrDISP = $masterData->getMasterData(“mtb_disp”);
\n$this->arrRECOMMEND = $masterData->getMasterData(“mtb_recommend”);
\n$this->arrCustomer_rank = $masterData->getMasterData(“mtb_customer_rank”); <\/span>
\n}<\/p><\/blockquote>\n
\n$this->arrJob[“\u4e0d\u660e”] = “\u4e0d\u660e”;
\n$this->arrSex = $masterData->getMasterData(“mtb_sex”);
\n$this->arrPageRows = $masterData->getMasterData(“mtb_page_rows”);
\n$this->arrMAILMAGATYPE = $masterData->getMasterData(“mtb_mail_magazine_type”);
\n$this->arrCustomer_rank = $masterData->getMasterData(“mtb_customer_rank”); <\/span>
\n$this->arrHtmlmail[”] = “\u3059\u3079\u3066”;<\/p><\/blockquote>\n
\n“csv” => “create_date”,
\n“header” => “\u767b\u9332\u65e5”),
\n26 => array(“sql” => “cast(update_date as date) AS update_date”,
\n“csv” => “update_date”,
\n“header” => “\u66f4\u65b0\u65e5”),
\n27 => array(“sql” => “customer_rank”,
\n“csv” => “customer_rank”,
\n“header” => “\u4f1a\u54e1\u30e9\u30f3\u30af”) <\/span>
\n);
\n}<\/p><\/blockquote>\n
\n(L188\u3042\u305f\u308a\uff09<\/strong><\/p>\n
\nforeach ($_POST as $key => $val) {
\nswitch($key) {
\ncase ‘sex’:
\ncase ‘status’:
\ncase ‘customer_rank’:<\/span>
\n$this->arrHidden[$key] = SC_Utils_Ex::sfMergeParamCheckBoxes($val);
\nif(!is_array($val)) {
\n$this->arrForm[$key] = split(“-“, $val);
\n}
\nbreak;<\/p><\/blockquote>\n
\nparent::init();
\n$this->tpl_mainpage = ‘customer\/edit.tpl’;
\n$this->tpl_mainno = ‘customer’;
\n$this->tpl_subnavi = ‘customer\/subnavi.tpl’;
\n$this->tpl_subno = ‘index’;
\n$this->tpl_pager = TEMPLATE_DIR . ‘admin\/pager.tpl’;
\n$this->tpl_subtitle = ‘\u9867\u5ba2\u30de\u30b9\u30bf’;<\/p>\n
\n$this->arrPref = $masterData->getMasterData(“mtb_pref”, array(“pref_id”, “pref_name”, “rank”));
\n$this->arrJob = $masterData->getMasterData(“mtb_job”);
\n$this->arrSex = $masterData->getMasterData(“mtb_sex”);
\n$this->arrReminder = $masterData->getMasterData(“mtb_reminder”);
\n$this->arrCustomer_rank = $masterData->getMasterData(“mtb_customer_rank”); <\/span>
\n}<\/p><\/blockquote>\n
\narray( “column” => “reminder_answer”, “convert” => “aKV” ),
\narray( “column” => “mailmaga_flg”, “convert” => “n” ),
\narray( “column” => “note”, “convert” => “aKV” ),
\narray( “column” => “point”, “convert” => “n” ),
\narray( “column” => “status”, “convert” => “n” ),<\/span>
\narray( “column” => “customer_rank”, “convert” => “n” )<\/span>
\n);<\/p><\/blockquote>\n
\n$objErr->doFunc(array(“\u3054\u8077\u696d”, “job”) ,array(“NUM_CHECK”));
\n$objErr->doFunc(array(“\u4f1a\u54e1\u30e9\u30f3\u30af”, “customer_rank”) ,array(“SELECT_CHECK”, “NUM_CHECK”)); <\/span>
\nif ($array[“password”] != DEFAULT_PASSWORD) {
\n$objErr->doFunc(array(“\u30d1\u30b9\u30ef\u30fc\u30c9”, ‘password’, PASSWORD_LEN1, PASSWORD_LEN2), array(“EXIST_CHECK”, “ALNUM_CHECK”, “NUM_RANGE_CHECK”));
\n}<\/p><\/blockquote>\n
\n$this->arrPref = $masterData->getMasterData(“mtb_pref”, array(“pref_id”, “pref_name”, “rank”));
\n$this->arrJob = $masterData->getMasterData(“mtb_job”);
\n$this->arrJob[“\u4e0d\u660e”] = “\u4e0d\u660e”;
\n$this->arrSex = $masterData->getMasterData(“mtb_sex”);
\n$this->arrCustomer_rank = $masterData->getMasterData(“mtb_customer_rank”);<\/span>
\n$this->arrMailType = $masterData->getMasterData(“mtb_mail_type”);
\n$this->arrPageRows = $masterData->getMasterData(“mtb_page_rows”);
\n\/\/ \u30da\u30fc\u30b8\u30ca\u30d3\u7528<\/p><\/blockquote>\n
\n$this->arrSearchColumn = array(
\narray( “column” => “name”, “convert” => “aKV”),
\narray( “column” => “pref”, “convert” => “n” ),
\narray( “column” => “kana”, “convert” => “CKV”),
\narray( “column” => “sex”, “convert” => “” ),
\narray( “column” => “customer_rank”, “convert” => “” ),<\/span>
\narray( “column” => “tel”, “convert” => “n” ),
\narray( “column” => “job”, “convert” => “” ),
\narray( “column” => “email”, “convert” => “a” ),<\/p><\/blockquote>\n
\n$list_data[‘htmlmail_disp’] = $this->arrHtmlmail[$list_data[‘htmlmail’]];<\/p>\n
\nif (count($list_data[‘sex’]) > 0) {
\nforeach($list_data[‘sex’] as $key => $val){
\n$list_data[‘sex’][$key] = $this->arrSex[$val];
\n$sex_disp .= $list_data[‘sex’][$key] . ” “;
\n}
\n$list_data[‘sex_disp’] = $sex_disp;
\n}<\/p>\n
\nif (count($list_data[‘customer_rank’]) > 0) {
\nforeach($list_data[‘customer_rank’] as $key => $val){
\n$list_data[‘customer_rank’][$key] = $this->arrCustomer_rank[$val];
\n$customer_rank_disp .= $list_data[‘customer_rank’][$key] . ” “;
\n}
\n$list_data[‘customer_rank_disp’] = $customer_rank_disp;
\n}<\/span><\/p>\n
\nif (count($list_data[‘job’]) > 0) {
\nforeach($list_data[‘job’] as $key => $val){
\n$list_data[‘job’][$key] = $this->arrJob[$val];
\n$job_disp .= $list_data[‘job’][$key] . ” “;
\n}
\n$list_data[‘job_disp’] = $job_disp;
\n}<\/p><\/blockquote>\n