$dao->rollback_trans(); $smarty->assign('message', '更新が失敗しました。'); } } catch (Exception $e) { $dao->rollback_trans(); $smarty->assign('message', 'DBエラーで失敗しました。'); } $id = $forms['id']; } $phase = 'complete'; } else { $phase = 'input'; } } } $categorydao = new Class_mp_service_category(); $sql = "select * from mp_service_category"; $categorydata = $categorydao->get_rows($sql); if (isset($categorydata)) { $smarty->assign('categorydata', $categorydata); } if (isset($forms)) { $smarty->assign('forms', $forms); } if (isset($err_mes)) { $smarty->assign('err', $err_mes); } if (isset($service_forms)) { $smarty->assign('forms', $service_forms); } $smarty->assign('phase', $phase);
<?php require_once '../system/smarty.inc'; require_once '../system/mdao/Class_mp_service_category.php'; require_once '../system/Class_ERROR.php'; require_once '../system/login.inc.php'; require_once '../system/prego_m.php'; $dao = new Class_mp_service_category(); if ($_SERVER['REQUEST_METHOD'] == 'GET') { $phase = 'input'; // get category data $sql = "select * from mp_service_category"; $forms = $dao->get_rows($sql); } else { $forms = $_POST; // set $forms['mutirow'] array if (isset($forms['category_id'])) { foreach ($forms['category_id'] as $k => $v) { $forms['mutirow'][] = array("id" => $v, "category_name" => $forms['category_name'][$k]); } } if ($forms['mode'] == 'input') { // check $forms['mutirow'] items $err = new Class_ERROR(); $index = 0; $category_chk = $dao->get_checks(); foreach ($forms['mutirow'] as $k => $v) { $err_mes['category_name'][$index] = $err->check($v['category_name'], $category_chk['category_name']); $index = $index + 1; } // verification check
<?php require_once '../system/smarty.inc'; require_once '../system/mdao/Class_mp_service_category.php'; $dao = new Class_mp_service_category(); $sql = "select * from mp_service_category"; $data = $dao->get_rows($sql); if (isset($data)) { $smarty->assign('data', $data); } $smarty->display('popup_category_select.html');
<?php require_once '../system/smarty.inc'; require_once '../system/mdao/Class_mp_service_category.php'; require_once '../system/mdao/Class_mp_service.php'; require_once '../system/mdao/Class_mp_spec_fee.php'; $category_dao = new Class_mp_service_category(); $service_dao = new Class_mp_service(); $spec_fee_dao = new Class_mp_spec_fee(); if ($_SERVER['REQUEST_METHOD'] == 'GET') { if (isset($_GET['model']) && $_GET['model'] != '') { $model = $_GET['model']; $smarty->assign('model', $model); } // else{ // $spec_id = $_GET['spec_id']; // echo "spec_id".$spec_id; // $spec_fee_sql = "select * from mp_spec_fee where id = '$spec_id'"; // $spec_data = $spec_fee_dao->get_rows($spec_fee_sql); // $wherearr = array(); // $service_menu_arr = array(); // foreach ($spec_data as $k => $v) { // $service_each_menu = $v['servers_menu']; // $service_menu_arr[] = "servers_menu = '$service_each_menu' "; // } // $where_service_menu = implode( ' OR ', $service_menu_arr); // $service_data = $service_dao->search($where_service_menu); // } if (isset($_GET['sid']) && $_GET['sid'] != '') { $spec_id = $_GET['sid']; $sql = "select * from mp_spec_fee where spec_id = '{$spec_id}' ";