の募集情報 件ヒットしました!
9 ORDER BY shop_course DESC, upper_update DESC LIMIT $start,$max_1p");
while($data = mysqli_fetch_array($recordSet)){
$shop_id = $data["shop_id"];
$shop_rank = $data["shop_rank"];
$shop_course = $data["shop_course"];
$shop_name = $data["shop_name"];
$shop_code = $data["shop_code"];
$shop_genre = $data["shop_genre"];
$shop_genre_name = genre_name($shop_genre);
$shop_area = $data["shop_area"];
$shop_addr= $data["shop_addr"];
$shop_addr2= $data["shop_addr2"];
$shop_tel = $data["shop_tel"];
$shop_pr = $data["shop_pr"];
$shop_costume = $data["shop_costume"];
$nyukin = $data["nyukin"];
$shop_update = $data["shop_update"];
//////////求人情報読み込み//////////
$rec_sql = "SELECT * FROM recruit WHERE rec_shop_id ='".$shop_id."'";
$rec_result = mysqli_query($con,$rec_sql) or die(mysqli_error());
$rec_id = "";
$rec_shop_id = "";
$rec_title = "";
$rec_message = "";
$rec_img_main = "";
$rec_syokusyu = "";
$rec_gyosyu = "";
$rec_kyuyo = "";
$rec_shikaku = "";
$rec_kinmuchi = "";
for($i=1; $i<37; $i++){${'rec_taigu_'.$i} = "";}
while($rec_data = mysqli_fetch_array($rec_result)){
$rec_id = $rec_data["rec_id"];
$rec_shop_id = $rec_data["rec_shop_id"];
$rec_title = $rec_data["rec_title"];
$rec_message = $rec_data["rec_message"];
$rec_message = str_replace("", " ", $rec_message); $rec_message_vip = mb_strimwidth($rec_message, 0, 680, "...","UTF-8"); $rec_message_standard = mb_strimwidth($rec_message, 0, 340, "...","UTF-8"); $rec_message_free = mb_strimwidth($rec_message, 0, 220, "...","UTF-8"); $rec_message_sb = mb_strimwidth($rec_message, 0, 110, "...","UTF-8"); $rec_img_main = $rec_data["rec_img_main"]; $rec_syokusyu = $rec_data["rec_syokusyu"]; $rec_kyuyo = $rec_data["rec_kyuyo"]; $rec_kyuyo = str_replace("
", " ", $rec_kyuyo); $rec_kyuyo_vip = mb_strimwidth($rec_kyuyo, 0, 80, "...","UTF-8"); $rec_kyuyo_standard = mb_strimwidth($rec_kyuyo, 0, 70, "...","UTF-8"); $rec_shikaku = $rec_data["rec_shikaku"]; $rec_shikaku = str_replace("
", " ", $rec_shikaku); $rec_shikaku_vip = mb_strimwidth($rec_shikaku, 0, 80, "...","UTF-8"); $rec_shikaku_standard = mb_strimwidth($rec_shikaku, 0, 70, "...","UTF-8"); $rec_kinmuchi = $rec_data["rec_kinmuchi"]; $rec_kinmuchi = str_replace("
", " ", $rec_kinmuchi); $rec_kinmuchi_vip = mb_strimwidth($rec_kinmuchi, 0, 80, "...","UTF-8"); $rec_kinmuchi_standard = mb_strimwidth($rec_kinmuchi, 0, 70, "...","UTF-8"); $rec_kinmuchi_free = mb_strimwidth($rec_kinmuchi, 0, 70, "...","UTF-8"); $rec_taigu_text = $rec_data["rec_taigu_text"]; for($i=1; $i<37; $i++){${'rec_taigu_'.$i} = $rec_data["rec_taigu_{$i}"];} $rec_update = $rec_data["rec_update"]; break; } //////////エリア読み込み////////// $area_sql = "SELECT * FROM area WHERE area_id ='".$shop_area."'"; $area_result = mysqli_query($con,$area_sql); while($area_data = mysqli_fetch_array($area_result)){ $area_id = $area_data["area_id"]; $area_name_en = $area_data["area_name_en"]; $area_name_jp = $area_data["area_name_jp"]; } //////////衣装読み込み////////// $costume_sql = "SELECT * FROM costume WHERE costume_id ='".$shop_costume."'"; $costume_result = mysqli_query($con,$costume_sql); while($costume_data = mysqli_fetch_array($costume_result)){ $costume_name_en = $costume_data["costume_name_en"]; $costume_name_jp = $costume_data["costume_name_jp"]; } ////////// ロイヤルVIP求人掲載コース( ※ 7/1 リリース予定 ) ////////// if($shop_course=="30"){ $body.= <<< SET
SET;
if ($rec_img_main) {
$body.= <<< SET
SET; } else { $body.= <<< SET
SET; } $body.= <<< SET
SET; } else { $body.= <<< SET
SET; } $body.= <<< SET
{$shop_tel} ♥ お店の人に「京町ばいと見ました!」と伝えると、対応がスムーズです。 |
{$shop_genre_name} | {$rec_kinmuchi_vip} | {$costume_name_jp} | |||
{$rec_kyuyo_vip} | |||||
《 待遇 》
-
SET;
for($i=1; $i<22; $i++){
$recname=${'rec_name_'.$i};
if(${'rec_taigu_'.$i} == "1"){
$body.= <<< SET
- {$recname}SET; } else { $body.= <<< SET{$recname}SET; } } $body.= <<< SET
《 給与 》
-
SET;
for($i=22; $i<31; $i++){
$recname=${'rec_name_'.$i};
if(${'rec_taigu_'.$i} == "1"){
$body.= <<< SET
- {$recname}SET; } else { $body.= <<< SET{$recname}SET; } } $body.= <<< SET
《 設備 》
-
SET;
for($i=31; $i<37; $i++){
$recname=${'rec_name_'.$i};
if(${'rec_taigu_'.$i} == "1"){
$body.= <<< SET
- {$recname}SET; } else { $body.= <<< SET{$recname}SET; } } $body.= <<< SET
SET;
if ($rec_img_main) {
$body.= <<< SET
SET; } else { $body.= <<< SET
SET; } $body.= <<< SET
SET; } else { $body.= <<< SET
SET; } $body.= <<< SET
{$shop_genre_name} | {$rec_kinmuchi_standard} | ||
{$costume_name_jp} | {$rec_kyuyo_standard} | ||
《 待遇 》
-
SET;
for($i=1; $i<22; $i++){
$recname=${'rec_name_'.$i};
if(${'rec_taigu_'.$i} == "1"){
$body.= <<< SET
- {$recname}SET; } else { $body.= <<< SET{$recname}SET; } } $body.= <<< SET
《 給与 》
-
SET;
for($i=22; $i<31; $i++){
$recname=${'rec_name_'.$i};
if(${'rec_taigu_'.$i} == "1"){
$body.= <<< SET
- {$recname}SET; } else { $body.= <<< SET{$recname}SET; } } $body.= <<< SET
《 設備 》
-
SET;
for($i=31; $i<37; $i++){
$recname=${'rec_name_'.$i};
if(${'rec_taigu_'.$i} == "1"){
$body.= <<< SET
- {$recname}SET; } else { $body.= <<< SET{$recname}SET; } } $body.= <<< SET
{$shop_name}
{$shop_genre_name} | {$rec_kinmuchi_free} | ||