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