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"];
