PHP Class_mp_service::get_rows Examples

Example #1

File: popup_service_master.php Project: BGCX262/zuozhenshi-prego-svn-to-git

        $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);
    }
}
$smarty->assign('category_data', $category_data);
$smarty->assign('service_data', $service_data);
$smarty->display('popup_service_master.html');