Changeset 20538 for branches/version-2_5-dev/data/class/helper
- Timestamp:
- 2011/03/07 15:23:39 (15 years ago)
- Location:
- branches/version-2_5-dev/data/class/helper
- Files:
-
- 7 edited
-
SC_Helper_CSV.php (modified) (3 diffs)
-
SC_Helper_Customer.php (modified) (14 diffs)
-
SC_Helper_DB.php (modified) (11 diffs)
-
SC_Helper_FileManager.php (modified) (2 diffs)
-
SC_Helper_Mail.php (modified) (5 diffs)
-
SC_Helper_Mobile.php (modified) (1 diff)
-
SC_Helper_Session.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/helper/SC_Helper_CSV.php
r20507 r20538 464 464 if($prefix == "") { 465 465 $dir_name = SC_Utils_Ex::sfUpDirName(); 466 $file_name = $dir_name . date( "ymdHis") .".csv";466 $file_name = $dir_name . date('ymdHis') .".csv"; 467 467 } else { 468 $file_name = $prefix . date( "ymdHis") .".csv";468 $file_name = $prefix . date('ymdHis') .".csv"; 469 469 } 470 470 … … 487 487 */ 488 488 function lfDownloadCSVFile($filepath, $prefix = "") { 489 $file_name = $prefix . date( "YmdHis") . ".csv";489 $file_name = $prefix . date('YmdHis') . ".csv"; 490 490 491 491 /* HTTPヘッダの出力 */ … … 507 507 if($prefix == "") { 508 508 $dir_name = SC_Utils_Ex::sfUpDirName(); 509 $file_name = $dir_name . date( "ymdHis") .".csv";509 $file_name = $dir_name . date('ymdHis') .".csv"; 510 510 } else { 511 $file_name = $prefix . date( "ymdHis") .".csv";511 $file_name = $prefix . date('ymdHis') .".csv"; 512 512 } 513 513 -
branches/version-2_5-dev/data/class/helper/SC_Helper_Customer.php
r20537 r20538 48 48 // salt値の生成(insert時)または取得(update時)。 49 49 if(is_numeric($customer_id)) { 50 $salt = $objQuery->get( "salt", "dtb_customer", "customer_id = ? ", array($customer_id));50 $salt = $objQuery->get('salt', "dtb_customer", "customer_id = ? ", array($customer_id)); 51 51 }else{ 52 52 $salt = SC_Utils_Ex::sfGetRandomString(10); 53 $array[ "salt"] = $salt;53 $array['salt'] = $salt; 54 54 } 55 55 //-- パスワードの更新がある場合は暗号化 56 if ($array[ "password"] == DEFAULT_PASSWORD or $array["password"] == "") {56 if ($array['password'] == DEFAULT_PASSWORD or $array['password'] == "") { 57 57 //更新しない 58 unset($array[ "password"]);58 unset($array['password']); 59 59 } else { 60 $array[ "password"] = SC_Utils_Ex::sfGetHashString($array["password"], $salt);60 $array['password'] = SC_Utils_Ex::sfGetHashString($array['password'], $salt); 61 61 } 62 62 //-- 秘密の質問の更新がある場合は暗号化 … … 103 103 if ($customer_id != "" && $customer_id >= 1) { 104 104 if (USE_POINT !== false) { 105 $arrRet = $objQuery->select( "point", "dtb_customer", "customer_id = ?", array($customer_id));105 $arrRet = $objQuery->select('point', "dtb_customer", "customer_id = ?", array($customer_id)); 106 106 $point = $arrRet[0]['point']; 107 107 $total_point = $arrRet[0]['point'] - $use_point + $add_point; … … 176 176 "dtb_customer", "customer_id = ?", 177 177 array($customer_id)); 178 if ($email == $arrResults[ "email"]178 if ($email == $arrResults['email'] 179 179 || $email == $arrResults["email_mobile"]) { 180 180 return true; … … 205 205 // 誕生日を年月日に分ける 206 206 if (isset($arrForm['birth'])){ 207 $birth = explode(" ", $arrForm[ "birth"]);207 $birth = explode(" ", $arrForm['birth']); 208 208 list($arrForm['year'], $arrForm['month'], $arrForm['day']) = explode("-",$birth[0]); 209 209 } … … 253 253 $count = 1; 254 254 while ($count != 0) { 255 $uniqid = SC_Utils_Ex::sfGetUniqRandomId( "r");255 $uniqid = SC_Utils_Ex::sfGetUniqRandomId('r'); 256 256 $count = $objQuery->count("dtb_customer", "secret_key = ?", array($uniqid)); 257 257 } … … 292 292 SC_Helper_Customer_Ex::sfCustomerRegisterParam($objFormParam, $isAdmin); 293 293 if($isAdmin) { 294 $objFormParam->addParam("顧客ID", "customer_id", INT_LEN, "n", array("NUM_CHECK"));295 $objFormParam->addParam('携帯メールアドレス', "email_mobile", MTEXT_LEN, "a", array("NO_SPTAB", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK"));296 $objFormParam->addParam("会員状態", "status", INT_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));297 $objFormParam->addParam("SHOP用メモ", "note", LTEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));298 $objFormParam->addParam("所持ポイント", "point", INT_LEN, "n", array("NUM_CHECK"));294 $objFormParam->addParam("顧客ID", "customer_id", INT_LEN, 'n', array("NUM_CHECK")); 295 $objFormParam->addParam('携帯メールアドレス', "email_mobile", MTEXT_LEN, 'a', array("NO_SPTAB", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK")); 296 $objFormParam->addParam("会員状態", 'status', INT_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 297 $objFormParam->addParam("SHOP用メモ", 'note', LTEXT_LEN, 'KVa', array("MAX_LENGTH_CHECK")); 298 $objFormParam->addParam("所持ポイント", 'point', INT_LEN, 'n', array("NUM_CHECK")); 299 299 300 300 } … … 312 312 SC_Helper_Customer_Ex::sfCustomerRegisterParam($objFormParam); 313 313 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE){ 314 $objFormParam->addParam('携帯メールアドレス', "email_mobile", MTEXT_LEN, "a", array("NO_SPTAB", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));315 $objFormParam->addParam('携帯メールアドレス(確認)', "email_mobile02", MTEXT_LEN, "a", array("NO_SPTAB", "EMAIL_CHECK","SPTAB_CHECK" , "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"), "", false);314 $objFormParam->addParam('携帯メールアドレス', "email_mobile", MTEXT_LEN, 'a', array("NO_SPTAB", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 315 $objFormParam->addParam('携帯メールアドレス(確認)', "email_mobile02", MTEXT_LEN, 'a', array("NO_SPTAB", "EMAIL_CHECK","SPTAB_CHECK" , "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"), "", false); 316 316 } 317 317 } … … 337 337 */ 338 338 function sfCustomerCommonParam (&$objFormParam) { 339 $objFormParam->addParam("お名前(姓)", 'name01', STEXT_LEN, "aKV", array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK"));340 $objFormParam->addParam("お名前(名)", 'name02', STEXT_LEN, "aKV", array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK"));341 $objFormParam->addParam("お名前(フリガナ・姓)", 'kana01', STEXT_LEN, "CKV", array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK"));342 $objFormParam->addParam("お名前(フリガナ・名)", 'kana02', STEXT_LEN, "CKV", array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK"));343 $objFormParam->addParam("郵便番号1", "zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK"));344 $objFormParam->addParam("郵便番号2", "zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK"));345 $objFormParam->addParam("都道府県", 'pref', INT_LEN, "n", array("EXIST_CHECK", "NUM_CHECK"));346 $objFormParam->addParam("住所1", "addr01", MTEXT_LEN, "aKV", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));347 $objFormParam->addParam("住所2", "addr02", MTEXT_LEN, "aKV", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));348 $objFormParam->addParam("お電話番号1", 'tel01', TEL_ITEM_LEN, "n", array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));349 $objFormParam->addParam("お電話番号2", 'tel02', TEL_ITEM_LEN, "n", array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));350 $objFormParam->addParam("お電話番号3", 'tel03', TEL_ITEM_LEN, "n", array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));339 $objFormParam->addParam("お名前(姓)", 'name01', STEXT_LEN, 'aKV', array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 340 $objFormParam->addParam("お名前(名)", 'name02', STEXT_LEN, 'aKV', array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK")); 341 $objFormParam->addParam("お名前(フリガナ・姓)", 'kana01', STEXT_LEN, 'CKV', array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 342 $objFormParam->addParam("お名前(フリガナ・名)", 'kana02', STEXT_LEN, 'CKV', array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 343 $objFormParam->addParam("郵便番号1", "zip01", ZIP01_LEN, 'n', array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 344 $objFormParam->addParam("郵便番号2", "zip02", ZIP02_LEN, 'n', array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 345 $objFormParam->addParam("都道府県", 'pref', INT_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK")); 346 $objFormParam->addParam("住所1", "addr01", MTEXT_LEN, 'aKV', array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 347 $objFormParam->addParam("住所2", "addr02", MTEXT_LEN, 'aKV', array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 348 $objFormParam->addParam("お電話番号1", 'tel01', TEL_ITEM_LEN, 'n', array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 349 $objFormParam->addParam("お電話番号2", 'tel02', TEL_ITEM_LEN, 'n', array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 350 $objFormParam->addParam("お電話番号3", 'tel03', TEL_ITEM_LEN, 'n', array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 351 351 } 352 352 … … 360 360 function sfCustomerRegisterParam (&$objFormParam, $isAdmin = false) { 361 361 if($isAdmin) { 362 $objFormParam->addParam("パスワード", 'password', STEXT_LEN, "a", array("SPTAB_CHECK", "ALNUM_CHECK", "MAX_LENGTH_CHECK"));363 $objFormParam->addParam("パスワード確認用の質問の答え", "reminder_answer", STEXT_LEN, "aKV", array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));362 $objFormParam->addParam("パスワード", 'password', STEXT_LEN, 'a', array("SPTAB_CHECK", "ALNUM_CHECK", "MAX_LENGTH_CHECK")); 363 $objFormParam->addParam("パスワード確認用の質問の答え", "reminder_answer", STEXT_LEN, 'aKV', array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 364 364 }else{ 365 $objFormParam->addParam("パスワード", 'password', STEXT_LEN, "a", array("EXIST_CHECK", "SPTAB_CHECK", "ALNUM_CHECK", "MAX_LENGTH_CHECK"));366 $objFormParam->addParam("パスワード確認用の質問の答え", "reminder_answer", STEXT_LEN, "aKV", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));367 } 368 $objFormParam->addParam("パスワード確認用の質問", "reminder", STEXT_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));369 $objFormParam->addParam("性別", "sex", INT_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));370 $objFormParam->addParam("職業", "job", INT_LEN, "n", array("NUM_CHECK", "MAX_LENGTH_CHECK"));371 $objFormParam->addParam("年", "year", 4, "n", array("NUM_CHECK", "MAX_LENGTH_CHECK"), "", false);372 $objFormParam->addParam("月", "month", 2, "n", array("NUM_CHECK", "MAX_LENGTH_CHECK"), "", false);373 $objFormParam->addParam("日", "day", 2, "n", array("NUM_CHECK", "MAX_LENGTH_CHECK"), "", false);374 $objFormParam->addParam("メールマガジン", "mailmaga_flg", INT_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));365 $objFormParam->addParam("パスワード", 'password', STEXT_LEN, 'a', array("EXIST_CHECK", "SPTAB_CHECK", "ALNUM_CHECK", "MAX_LENGTH_CHECK")); 366 $objFormParam->addParam("パスワード確認用の質問の答え", "reminder_answer", STEXT_LEN, 'aKV', array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 367 } 368 $objFormParam->addParam("パスワード確認用の質問", 'reminder', STEXT_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 369 $objFormParam->addParam("性別", 'sex', INT_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 370 $objFormParam->addParam("職業", 'job', INT_LEN, 'n', array("NUM_CHECK", "MAX_LENGTH_CHECK")); 371 $objFormParam->addParam("年", 'year', 4, 'n', array("NUM_CHECK", "MAX_LENGTH_CHECK"), "", false); 372 $objFormParam->addParam("月", 'month', 2, 'n', array("NUM_CHECK", "MAX_LENGTH_CHECK"), "", false); 373 $objFormParam->addParam("日", 'day', 2, 'n', array("NUM_CHECK", "MAX_LENGTH_CHECK"), "", false); 374 $objFormParam->addParam("メールマガジン", "mailmaga_flg", INT_LEN, 'n', array("EXIST_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK")); 375 375 376 376 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE){ 377 $objFormParam->addParam("FAX番号1", 'fax01', TEL_ITEM_LEN, "n", array("SPTAB_CHECK"));378 $objFormParam->addParam("FAX番号2", 'fax02', TEL_ITEM_LEN, "n", array("SPTAB_CHECK"));379 $objFormParam->addParam("FAX番号3", 'fax03', TEL_ITEM_LEN, "n", array("SPTAB_CHECK"));380 $objFormParam->addParam('メールアドレス', "email", MTEXT_LEN, "a", array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));377 $objFormParam->addParam("FAX番号1", 'fax01', TEL_ITEM_LEN, 'n', array("SPTAB_CHECK")); 378 $objFormParam->addParam("FAX番号2", 'fax02', TEL_ITEM_LEN, 'n', array("SPTAB_CHECK")); 379 $objFormParam->addParam("FAX番号3", 'fax03', TEL_ITEM_LEN, 'n', array("SPTAB_CHECK")); 380 $objFormParam->addParam('メールアドレス', 'email', MTEXT_LEN, 'a', array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 381 381 if(!$isAdmin) { 382 $objFormParam->addParam("パスワード(確認)", 'password02', STEXT_LEN, "a", array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK"), "", false);383 $objFormParam->addParam('メールアドレス(確認)', "email02", MTEXT_LEN, "a", array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK","SPTAB_CHECK" , "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"), "", false);382 $objFormParam->addParam("パスワード(確認)", 'password02', STEXT_LEN, 'a', array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK"), "", false); 383 $objFormParam->addParam('メールアドレス(確認)', "email02", MTEXT_LEN, 'a', array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK","SPTAB_CHECK" , "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"), "", false); 384 384 } 385 385 } else { 386 $objFormParam->addParam('メールアドレス', "email", MTEXT_LEN, "a", array("EXIST_CHECK", "EMAIL_CHECK", "NO_SPTAB" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK","MOBILE_EMAIL_CHECK"));386 $objFormParam->addParam('メールアドレス', 'email', MTEXT_LEN, 'a', array("EXIST_CHECK", "EMAIL_CHECK", "NO_SPTAB" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK","MOBILE_EMAIL_CHECK")); 387 387 } 388 388 } … … 477 477 */ 478 478 function sfCustomerRegisterErrorCheck(&$objErr, $isAdmin = false) { 479 $objErr->doFunc(array("生年月日", "year", "month", "day"), array("CHECK_BIRTHDAY"));479 $objErr->doFunc(array("生年月日", 'year', 'month', 'day'), array("CHECK_BIRTHDAY")); 480 480 481 481 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE){ 482 482 if(!$isAdmin) { 483 $objErr->doFunc(array('パスワード', 'パスワード(確認)', "password", "password02") ,array("EQUAL_CHECK"));484 $objErr->doFunc(array('メールアドレス', 'メールアドレス(確認)', "email", "email02") ,array("EQUAL_CHECK"));483 $objErr->doFunc(array('パスワード', 'パスワード(確認)', 'password', "password02") ,array("EQUAL_CHECK")); 484 $objErr->doFunc(array('メールアドレス', 'メールアドレス(確認)', 'email', "email02") ,array("EQUAL_CHECK")); 485 485 } 486 486 $objErr->doFunc(array("FAX番号", "fax01", "fax02", "fax03") ,array("TEL_CHECK")); … … 489 489 if(!$isAdmin) { 490 490 // 現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 491 $objErr->doFunc(array("メールアドレス", "email"), array("CHECK_REGIST_CUSTOMER_EMAIL"));491 $objErr->doFunc(array("メールアドレス", 'email'), array("CHECK_REGIST_CUSTOMER_EMAIL")); 492 492 } 493 493 return $objErr; … … 538 538 $objFormParam->addParam('購入商品名', 'search_buy_product_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 539 539 $objFormParam->addParam('カテゴリ', 'search_category_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 540 $objFormParam->addParam('性別', 'search_sex', INT_LEN, "n", array("MAX_LENGTH_CHECK"));541 $objFormParam->addParam('会員状態', 'search_status', INT_LEN, "n", array("MAX_LENGTH_CHECK"));542 $objFormParam->addParam('職業', 'search_job', INT_LEN, "n", array("MAX_LENGTH_CHECK"));540 $objFormParam->addParam('性別', 'search_sex', INT_LEN, 'n', array("MAX_LENGTH_CHECK")); 541 $objFormParam->addParam('会員状態', 'search_status', INT_LEN, 'n', array("MAX_LENGTH_CHECK")); 542 $objFormParam->addParam('職業', 'search_job', INT_LEN, 'n', array("MAX_LENGTH_CHECK")); 543 543 } 544 544 … … 593 593 function sfGetSearchData($arrParam) { 594 594 $objQuery =& SC_Query_Ex::getSingletonInstance(); 595 $objSelect = new SC_CustomerList_Ex($arrParam, "customer");595 $objSelect = new SC_CustomerList_Ex($arrParam, 'customer'); 596 596 $page_max = SC_Utils_Ex::sfGetSearchPageMax($arrParam['search_page_max']); 597 597 $disp_pageno = $arrParam['search_pageno']; … … 611 611 $linemax, 612 612 $page_max, 613 "fnNaviSearchOnlyPage",613 'fnNaviSearchOnlyPage', 614 614 NAVI_PMAX); 615 615 return array($linemax, $arrData, $objNavi); -
branches/version-2_5-dev/data/class/helper/SC_Helper_DB.php
r20507 r20538 215 215 $customer_id = $arrRet[0]['customer_id']; 216 216 if($customer_id != "" && $customer_id >= 1) { 217 $arrRet = $objQuery->select( "point", "dtb_customer", "customer_id = ?", array($customer_id));217 $arrRet = $objQuery->select('point', "dtb_customer", "customer_id = ?", array($customer_id)); 218 218 $point = $arrRet[0]['point']; 219 219 $rollback_point = $arrRet[0]['point'] + $use_point - $add_point; … … 549 549 } 550 550 // 最上位ランクを取得 551 $max = ($max < $val[ "rank"]) ? $val["rank"] : $max;552 } 553 $sqlval[ "rank"] = $max + 1;551 $max = ($max < $val['rank']) ? $val['rank'] : $max; 552 } 553 $sqlval['rank'] = $max + 1; 554 554 $objQuery->insert("dtb_product_categories", $sqlval); 555 555 } … … 581 581 } 582 582 // 最下位ランクを取得 583 $min = ($min < $val[ "rank"]) ? $val["rank"] : $min;584 } 585 $sqlval[ "rank"] = $min;583 $min = ($min < $val['rank']) ? $val['rank'] : $min; 584 } 585 $sqlval['rank'] = $min; 586 586 $objQuery->insert("dtb_product_categories", $sqlval); 587 587 } … … 984 984 } 985 985 // 対象項目のランクを取得 986 $rank = $objQuery->get( "rank", $table, $where, array($id));986 $rank = $objQuery->get('rank', $table, $where, array($id)); 987 987 // ランクの最大値を取得 988 $maxrank = $objQuery->max( "rank", $table, $andwhere);988 $maxrank = $objQuery->max('rank', $table, $andwhere); 989 989 // ランクが最大値よりも小さい場合に実行する。 990 990 if($rank < $maxrank) { … … 1024 1024 } 1025 1025 // 対象項目のランクを取得 1026 $rank = $objQuery->get( "rank", $table, $where, array($id));1026 $rank = $objQuery->get('rank', $table, $where, array($id)); 1027 1027 1028 1028 // ランクが1(最小値)よりも大きい場合に実行する。 … … 1066 1066 $getWhere = "$keyIdColumn = ?"; 1067 1067 } 1068 $rank = $objQuery->get( "rank", $tableName, $getWhere, array($keyId));1069 1070 $max = $objQuery->max( "rank", $tableName, $where);1068 $rank = $objQuery->get('rank', $tableName, $getWhere, array($keyId)); 1069 1070 $max = $objQuery->max('rank', $tableName, $where); 1071 1071 1072 1072 // 値の調整(逆順) … … 1086 1086 1087 1087 // XXX 入れ替え先の順位が入れ替え元の順位と同じ場合 1088 if (!isset($term)) $term = "rank";1088 if (!isset($term)) $term = 'rank'; 1089 1089 1090 1090 // 指定した順位の商品から移動させる商品までのrankを1つずらす … … 1129 1129 $where.= " AND $andwhere"; 1130 1130 } 1131 $rank = $objQuery->get( "rank", $table, $where, array($id));1131 $rank = $objQuery->get('rank', $table, $where, array($id)); 1132 1132 1133 1133 if(!$delete) { … … 1174 1174 } 1175 1175 1176 $objQuery->setOrder( "level");1176 $objQuery->setOrder('level'); 1177 1177 $arrRet = $objQuery->select($col, $table, $where, $arrId); 1178 1178 return $arrRet; … … 1198 1198 // 移動レコードのランクを取得する。 1199 1199 $where = "$id_name = ?"; 1200 $rank = $objQuery->get( "rank", $table, $where, array($id));1200 $rank = $objQuery->get('rank', $table, $where, array($id)); 1201 1201 // 削除レコードのランクより上のレコードを一つ下にずらす。 1202 1202 $where = "rank > ? AND $cat_name = ?"; … … 1205 1205 // 新カテゴリでの登録処理 1206 1206 // 新カテゴリの最大ランクを取得する。 1207 $max_rank = $objQuery->max( "rank", $table, "$cat_name = ?", array($new_catid)) + 1;1207 $max_rank = $objQuery->max('rank', $table, "$cat_name = ?", array($new_catid)) + 1; 1208 1208 $where = "$id_name = ?"; 1209 1209 $sqlup = "UPDATE $table SET rank = ? WHERE $where"; -
branches/version-2_5-dev/data/class/helper/SC_Helper_FileManager.php
r20534 r20538 330 330 $str = ""; 331 331 // バイナリモードでオープン 332 $fp = @fopen($filename, "rb");332 $fp = @fopen($filename, 'rb' ); 333 333 //ファイル内容を全て変数に読み込む 334 334 if($fp) { … … 347 347 */ 348 348 function sfWriteFile($filename, $value) { 349 $fp = @fopen($filename, "w");349 $fp = @fopen($filename, 'w'); 350 350 // ファイルに書き込む 351 351 if($fp) { -
branches/version-2_5-dev/data/class/helper/SC_Helper_Mail.php
r20507 r20538 125 125 $customer_id = $arrOrder['customer_id']; 126 126 $objQuery->setOrder('customer_id'); 127 $arrRet = $objQuery->select( "point", "dtb_customer", "customer_id = ?", array($customer_id));127 $arrRet = $objQuery->select('point', "dtb_customer", "customer_id = ?", array($customer_id)); 128 128 $arrCustomer = isset($arrRet[0]) ? $arrRet[0] : ""; 129 129 … … 136 136 137 137 foreach($arrOther as $other_key => $other_val){ 138 if(SC_Utils_Ex::sfTrim($other_val[ "value"]) == ""){139 $arrOther[$other_key][ "value"] = "";138 if(SC_Utils_Ex::sfTrim($other_val['value']) == ""){ 139 $arrOther[$other_key]['value'] = ""; 140 140 } 141 141 } … … 285 285 286 286 $objMailText = new SC_SiteView_Ex(); 287 $objMailText->assign( "CONF", $CONF);287 $objMailText->assign('CONF', $CONF); 288 288 $objMailText->assign("name01", $arrCustomerData['name01']); 289 289 $objMailText->assign("name02", $arrCustomerData['name02']); 290 $objMailText->assign( "uniqid", $arrCustomerData['secret_key']);290 $objMailText->assign('uniqid', $arrCustomerData['secret_key']); 291 291 $objMailText->assignobj($arrCustomerData); 292 292 $objMailText->assignobj($this); … … 319 319 $to_addr = $arrCustomerData["email_mobile"]; 320 320 }else{ 321 $to_addr = $arrCustomerData[ "email"];321 $to_addr = $arrCustomerData['email']; 322 322 } 323 323 $objMail->setTo($to_addr, $arrCustomerData["name01"] . $arrCustomerData["name02"] ." 様"); … … 414 414 415 415 // 顧客名の変換 416 $customerName = trim($arrDestination[ "name"]);417 $subjectBody = preg_replace("/{name}/", $customerName, $arrMail[ "subject"]);418 $mailBody = preg_replace("/{name}/", $customerName, $arrMail[ "body"]);416 $customerName = trim($arrDestination['name']); 417 $subjectBody = preg_replace("/{name}/", $customerName, $arrMail['subject']); 418 $mailBody = preg_replace("/{name}/", $customerName, $arrMail['body']); 419 419 420 420 $objMail->setItem( 421 $arrDestination[ "email"],421 $arrDestination['email'], 422 422 $subjectBody, 423 423 $mailBody, -
branches/version-2_5-dev/data/class/helper/SC_Helper_Mobile.php
r20534 r20538 398 398 ,DB_FETCHMODE_ORDERED 399 399 ); 400 400 401 401 if (!isset($arrRow)) { 402 402 return false; -
branches/version-2_5-dev/data/class/helper/SC_Helper_Session.php
r20507 r20538 27 27 function SC_Helper_Session() { 28 28 $this->objDb = new SC_Helper_DB_Ex(); 29 session_set_save_handler(array(&$this, "sfSessOpen"),30 array(&$this, "sfSessClose"),31 array(&$this, "sfSessRead"),32 array(&$this, "sfSessWrite"),33 array(&$this, "sfSessDestroy"),34 array(&$this, "sfSessGc"));29 session_set_save_handler(array(&$this, 'sfSessOpen'), 30 array(&$this, 'sfSessClose'), 31 array(&$this, 'sfSessRead'), 32 array(&$this, 'sfSessWrite'), 33 array(&$this, 'sfSessDestroy'), 34 array(&$this, 'sfSessGc')); 35 35 } 36 36
Note: See TracChangeset
for help on using the changeset viewer.
