Esempi in PHP per SSP::jp_complex

Esempio n. 1

File: assets.php Progetto: jpbalderas17/ams

//     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;