public function uploadCSV($filePath) { require_once "modeltiary/ipfDB.php"; $ins_ipfDB = new ipfDB(); require_once "modeltiary/table_class/entry.php"; $ins_entry = new entry(); //$ins_ipfDB->ini("entry"); $cntOk = 0; $cntFalid = 0; if (($handle = fopen($filePath, "r")) !== FALSE) { // setlocale(LC_ALL, 'ja_JP'); setlocale(LC_ALL, 'ja_JP.UTF-8'); //UTF-8の場合 while (($data = $this->fgetcsv_reg($handle)) !== FALSE) { //項目数判断 if (count($data) < 11) { $cntFalid = "正しいのCSVファイル選択ください"; continue; } $_enc_to = mb_internal_encoding(); $_enc_from = mb_detect_order(); // mb_convert_variables($_enc_to,$_enc_from,$data); /* $checkphone = $ins_entry->check_shop_phone($data[2]); if($checkphone==0){ unset($_DATA); $_DATA = array(); $shop_category =""; for($i=10;$i<16;$i++){ if($data[$i]=="1"){ $shop_category .=($i-9).","; } } if($shop_category!="") $shop_category = substr($shop_category, 0, -1); $_DATA['shoptbl']['shop_category'] = $shop_category;//カテゴリ $_DATA['shoptbl']['shop_name'] = $data[0];//店舗名 $_DATA['shoptbl']['shop_name_kana'] = $data[1];//店舗名(カタカナ) $_DATA['shoptbl']['shop_pref'] = $data[3];//都道府県 $_DATA['shoptbl']['shop_city'] = $data[4];//地域 $_DATA['shoptbl']['shop_address'] = $data[5];//住所 $_DATA['shoptbl']['shop_phone'] = $data[2];//電話番号 // $_DATA['shoptbl']['shop_img'] = ""; $_DATA['shoptbl']['shop_opentime'] = $data[7];//営業時間 $_DATA['shoptbl']['shop_holiday'] = $data[8];//定休日 $_DATA['shoptbl']['shop_homepage'] = $data[9];//ホームページ $_DATA['shoptbl']['shop_access'] = $data[6];//アクセス // $_DATA['shoptbl']['shop_keyword'] = $data[10];//検索ワード $_DATA['shoptbl']['shop_addtime'] = date("Y-m-d H:i:s"); $ins_entry->insert_shop_data($_DATA); $cntOk = $cntOk + 1; } */ $terminal = array("携帯" => "0", "PC" => "1"); $mailmgz = array("希望する" => "0", "希望しない" => "1"); unset($_DATA); $_DATA = array(); $_DATA['users']['password'] = $data[2]; //パスワード $_DATA['users']['email'] = $data[7]; //メールアドレス $_DATA['users']['created'] = $data[11]; //登録時間 $_DATA['users']['cmflag'] = 1; //登録媒体 $_DATA['users']['activated'] = 1; $_DATA['users']['terminal'] = $terminal[$data[8]]; //登録端末 $userid = $ins_ipfDB->dataControl("insert", $_DATA); unset($_DATA); $_DATA['users_info']['fullname'] = $data[0]; //名前 $_DATA['users_info']['fullname_kana'] = $data[1]; //フリガナ $_DATA['users_info']['zipcode'] = $data[3]; //郵便番号 $_DATA['users_info']['todoufuken'] = $data[4]; //都道府県 $_DATA['users_info']['banti'] = $data[5]; //住所 $_DATA['users_info']['phonenumber'] = $data[6]; //電話番号 $_DATA['users_info']['mailmgz'] = $mailmgz[$data[9]]; //ホームページ $_DATA['users_info']['birthday'] = $data[10]; //生年月日 $_DATA['users_info']['userid'] = $userid; //ID $ins_ipfDB->dataControl("insert", $_DATA); unset($_DATA); $cntOk = $cntOk + 1; } fclose($handle); } return array($cntOk, $cntFalid); }
if (!$sysinfo['user_id']) { header('Location: login.php'); exit; } if ($error_flag == 0) { $comment = $_POST['comment']; $commenterId = $sysinfo['user_id']; if ($comment != "" && mb_strlen($comment, 'UTF-8') <= 100) { unset($_DATA); $_DATA = array(); $_DATA['coupon_comment']['comment'] = $comment; $_DATA['coupon_comment']['coupon_id'] = $coupon_id; $_DATA['coupon_comment']['user_id'] = $sysinfo['user_id']; $_DATA['coupon_comment']['pic_url'] = $_POST["up_img"]; $_DATA['coupon_comment']['addtime'] = date('Y-m-d H:i:s'); $ins_ipfDB->dataControl("insert", $_DATA); } else { $PAGE_VALUE['comment_err'] = "※入力に誤りがあります。100文字以内で入力して下さい"; } } } $couponData = $cinderella->selectCouponByID($coupon_id); if (count($couponData) > 0) { $PAGE_VALUE['shop_id'] = $couponData["shop_id"]; $PAGE_VALUE['shop_name'] = $couponData["shop_name"]; $PAGE_VALUE['shop_address'] = $couponData["address"]; $PAGE_VALUE['shop_email'] = $couponData["email"]; $PAGE_VALUE['shop_phone'] = $couponData["phone"]; $PAGE_VALUE['shop_station'] = $couponData["station"]; $PAGE_VALUE['shop_pref'] = $couponData["pref"]; $PAGE_VALUE['shop_zip'] = $couponData["zip"];
mb_regex_encoding('UTF-8'); mb_internal_encoding("UTF-8"); $_DATA = array(); $_DATA['coupon']['category'] = implode(',', $_POST['category']); $_DATA['coupon']['title'] = $_POST['title']; $_DATA['coupon']['pic_url'] = $_POST["up_img"]; $_DATA['coupon']['description'] = $_POST['description']; $_DATA['coupon']['before_price'] = $_POST["before_price"]; $_DATA['coupon']['after_price'] = $_POST["after_price"]; $exp_date_from = $_POST["exp_date_from_y"] . "-" . $_POST["exp_date_from_m"] . "-" . $_POST["exp_date_from_d"]; $exp_date_until = $_POST["exp_date_until_y"] . "-" . $_POST["exp_date_until_m"] . "-" . $_POST["exp_date_until_d"]; $_DATA['coupon']['exp_date_from'] = $exp_date_from; $_DATA['coupon']['exp_date_until'] = $exp_date_until; $_DATA['coupon']['warning'] = $_POST["coupon_warning"]; $_DATA['coupon']['addtime'] = date('Y-m-d H:i:s'); $coupon_id = $ins_ipfDB->dataControl("insert", $_DATA); unset($_DATA); $_DATA = array(); $_DATA['coupon_x_shop']['shop_id'] = $_POST["shop_id"]; $_DATA['coupon_x_shop']['coupon_id'] = $coupon_id; $ins_ipfDB->dataControl("insert", $_DATA); $tagArray = mb_split('[[:space:]]', $_POST['tag']); for ($i = 0; $i < count($tagArray); $i++) { if ($tagArray[$i] != "" && is_string($tagArray[$i])) { $id = $cinderella_admin->selectTagExists($tagArray[$i]); if (!$id) { unset($_DATA); $_DATA = array(); $_DATA['coupon_tag']['name'] = $tagArray[$i]; $_DATA['coupon_tag']['delete_flag'] = 0; $_DATA['coupon_tag']['addtime'] = date("Y-m-d H:i:s");
mb_regex_encoding('UTF-8'); mb_internal_encoding("UTF-8"); $_DATA = array(); $_DATA['coupon']['category'] = implode(',', $_POST['category']); $_DATA['coupon']['title'] = $_POST['title']; $_DATA['coupon']['pic_url'] = $_POST["up_img"]; $_DATA['coupon']['warning'] = $_POST['warning']; $_DATA['coupon']['description'] = $_POST['description']; $_DATA['coupon']['before_price'] = $_POST["before_price"]; $_DATA['coupon']['after_price'] = $_POST["after_price"]; $_DATA['coupon']['osusume_flag'] = isset($_POST['osusume']) ? "1" : "0"; $exp_date_from = $_POST["exp_date_from_y"] . "-" . $_POST["exp_date_from_m"] . "-" . $_POST["exp_date_from_d"]; $exp_date_until = $_POST["exp_date_until_y"] . "-" . $_POST["exp_date_until_m"] . "-" . $_POST["exp_date_until_d"]; $_DATA['coupon']['exp_date_from'] = $exp_date_from; $_DATA['coupon']['exp_date_until'] = $exp_date_until; $ins_ipfDB->dataControl("update", "id = " . $_GET["aid"]); unset($_DATA); $_DATA = array(); $_DATA['coupon_x_shop']['shop_id'] = $_POST["shop_id"]; $_DATA['coupon_x_shop']['coupon_id'] = $_GET["aid"]; $ins_ipfDB->dataControl("update", "id = " . $_GET["aid"]); $cinderella_admin->deleteAllTagByCouponId($_GET["aid"]); $tagArray = mb_split('[[:space:]]', $_POST['tag']); for ($i = 0; $i < count($tagArray); $i++) { if ($tagArray[$i] != "" && is_string($tagArray[$i])) { $id = $cinderella_admin->selectTagExists($tagArray[$i]); if (!$id) { unset($_DATA); $_DATA = array(); $_DATA['coupon_tag']['name'] = $tagArray[$i]; $_DATA['coupon_tag']['delete_flag'] = 0;
$_DATA['shop']['pic_url2'] = $_POST["pic_url2"]; $_DATA['shop']['pic_url3'] = $_POST["pic_url3"]; $_DATA['shop']['station'] = $_POST['eki']; $_DATA['shop']['pref'] = $_POST['todoufukens']; $_DATA['shop']['address'] = $_POST["address"]; $_DATA['shop']['zip'] = $_POST["zip"]; $_DATA['shop']['email'] = $_POST["email"]; $_DATA['shop']['average_price'] = $_POST["average_price"]; $_DATA['shop']['website'] = $_POST["shop_website"]; $_DATA['shop']['detail'] = $_POST["shop_details"]; $_DATA['shop']['eigyo_jikan'] = $_POST["eigyo_jikan"]; $_DATA['shop']['access'] = $_POST["access"]; $_DATA['shop']['holiday'] = $_POST["holiday"]; $_DATA['shop']['phone'] = $_POST["phone"]; $_DATA['shop']['addtime'] = date('Y-m-d H:i:s'); $ins_ipfDB->dataControl("update", "id = " . $_GET["sid"]); header('Location: main.php'); } else { $PAGE_VALUE["name"] = $_POST["name"]; $PAGE_VALUE["todoufukens"] = setOptions($todoufukens, $_POST['todoufukens']); $PAGE_VALUE["zip"] = $_POST["zip"]; $PAGE_VALUE["address"] = $_POST["address"]; $PAGE_VALUE["eki"] = $_POST["eki"]; $PAGE_VALUE["access"] = $_POST["access"]; $PAGE_VALUE["eigyo_jikan"] = $_POST["eigyo_jikan"]; $PAGE_VALUE["holiday"] = $_POST["holiday"]; $PAGE_VALUE["email"] = $_POST["email"]; $PAGE_VALUE["phone"] = $_POST["phone"]; $PAGE_VALUE["shop_website"] = $_POST["shop_website"]; $PAGE_VALUE["shop_details"] = $_POST["shop_details"]; $PAGE_VALUE["average_price"] = $_POST["average_price"];