本文整理汇总了PHP中SSP::jp_complex方法的典型用法代码示例。如果您正苦于以下问题:PHP SSP::jp_complex方法的具体用法?PHP SSP::jp_complex怎么用?PHP SSP::jp_complex使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SSP
的用法示例。
在下文中一共展示了SSP::jp_complex方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: array
// SSP::simple( $_GET, $con, $table, $primaryKey, $columns )
// );
if ($_GET['status'] == "All") {
$json = SSP::jp_complex($_GET, $con, "qry_assets", $primaryKey, $columns, NULL, array("is_deleted=0"));
} else {
if ($_GET['status'] != 'Deployed') {
if ($_GET['status'] == 'Deployable') {
//is_deleted=0 AND asset_status_label=? AND qry_assets.user_id=0
$json = SSP::jp_complex($_GET, $con, "qry_assets", $primaryKey, $columns, NULL, array("is_deleted=0", "asset_status_label = :status", "qry_assets.user_id=0"));
} else {
//is_deleted=0 AND asset_status_label=?
$json = SSP::jp_complex($_GET, $con, "qry_assets", $primaryKey, $columns, NULL, array("is_deleted=0", "asset_status_label = :status"));
}
} else {
//is_deleted=0 AND check_out_date<>'0000-00-00'
$json = SSP::jp_complex($_GET, $con, "qry_assets", $primaryKey, $columns, NULL, array("is_deleted=0", "check_out_date <> '0000-00-00'"));
}
}
$limit = SSP::limit($_GET, $columns);
$order = SSP::order($_GET, $columns);
$where = SSP::filter($_GET, $columns, $bindings);
$whereAll = "";
$whereResult = "";
$filter_sql = "";
$dep_sql = "";
$user_sql = "";
$get_val = "";
if (!empty($_GET['d_id'])) {
$dep_sql = "u.department_id=:department_id";
$inputs['department_id'] = $_GET['d_id'];
$filter_sql .= $dep_sql;