PHP Class_mp_service::search Exemples

Exemple #1

Fichier : service_list.php Projet : BGCX262/zuozhenshi-prego-svn-to-git

$dao = new Class_mp_service();
if (isset($_POST['csv']) && $_POST['csv'] == "download" || isset($_POST['hist']) && $_POST['hist'] == "2") {
    $forms = $_SESSION['MSEARCH']['service_list'];
} else {
    $forms = $_POST;
    $_SESSION['MSEARCH']['service_list'] = $forms;
}
$wherearr = array();
$page = array();
if (isset($forms['page']) && is_numeric($forms['page'])) {
    $page['current'] = $forms['page'];
} else {
    $page['current'] = 1;
}
$page['item'] = PAGE_MAX;
$data = $dao->search($wherearr, $page);
// キャプション、メモ
$caption_arr = array();
$memo_arr = array();
$order = array("\n");
$replace = "<br/>";
foreach ($data as $k => $v) {
    if ($v['caption'] != '') {
        $caption_arr[$k] = str_replace($order, $replace, $v['caption']);
    }
    if ($v['memo'] != '') {
        $memo_arr[$k] = str_replace($order, $replace, $v['memo']);
    }
}
if (isset($forms)) {
    $smarty->assign('forms', $forms);

Exemple #2

Fichier : popup_service_master.php Projet : BGCX262/zuozhenshi-prego-svn-to-git

 // $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}' ";
     $spec_data = $spec_fee_dao->get_rows($sql);
     $wherearr = array();
     $service_id_arr = array();
     foreach ($spec_data as $k => $v) {
         $service_each_id = $v['service_id'];
         $service_id_arr[] = "id = '{$service_each_id}' ";
     }
     $service_where = implode(' OR ', $service_id_arr);
     $wherearr[] = "( {$service_where} )";
     $service_data = $service_dao->search($wherearr);
     $category_data = array();
     $category_id_temp = array();
     foreach ($service_data as $k => $v) {
         if (!in_array($v['category_id'], $category_id_temp)) {
             $category_id_temp[] = $v['category_id'];
             $category_id = $v['category_id'];
             $category_data[] = $category_dao->get($category_id);
         }
     }
 } else {
     $service_sql = "select * from mp_service";
     $service_data = $service_dao->get_rows($service_sql);
     $category_sql = "select * from mp_service_category";
     $category_data = $category_dao->get_rows($category_sql);
 }