private function save($table_name, $table_column, $value, $item_id) { $field_type = wpl_global::get_db_field_type($table_name, $table_column); if ($field_type == 'datetime' or $field_type == 'date') { $value = wpl_render::derender_date($value); } else { $value = wpl_db::escape($value); } $res = wpl_db::set($table_name, $item_id, $table_column, $value, 'id'); $res = (int) $res; $message = $res ? __('Saved.', WPL_TEXTDOMAIN) : __('Error Occured.', WPL_TEXTDOMAIN); $data = NULL; $response = array('success' => $res, 'message' => $message, 'data' => $data); echo json_encode($response); exit; }
} if (trim($listing_types_str)) { $query .= " AND `listing` IN ({$listing_types_str})"; } } $done_this = true; } elseif ($format == 'datemin' and !$done_this) { _wpl_import('libraries.render'); $min = $value; $max = isset($vars['sf_datemax_' . $table_column]) ? $vars['sf_datemax_' . $table_column] : ''; if (trim($min) != '') { $min = wpl_render::derender_date($min); $query .= " AND `" . $table_column . "` >= '" . $min . "'"; } if (trim($max) != '') { $max = wpl_render::derender_date($max); $query .= " AND `" . $table_column . "` <= '" . $max . "'"; } $done_this = true; } elseif ($format == 'gallery' and !$done_this) { if ($value != '-1' and trim($value) != '') { $query .= " AND (`pic_numb`>0)"; } $done_this = true; } elseif ($format == 'tmin' and !$done_this) { if ($value != '-1' and trim($value) != '') { $min = $value; $max = isset($vars['sf_tmax_' . $table_column]) ? $vars['sf_tmax_' . $table_column] : 999999999999; $query .= " AND `" . $table_column . "` >= '" . $min . "' AND `" . $table_column . "` <= '" . $max . "'"; } $done_this = true;
if (trim($listing_types_str)) { $query .= " AND `listing` IN ({$listing_types_str})"; } } $done_this = true; } elseif ($format == 'datemin' and !$done_this) { _wpl_import('libraries.render'); if (trim($value) != '') { $value = wpl_render::derender_date($value); $query .= " AND DATE(`" . $table_column . "`) >= '" . $value . "'"; } $done_this = true; } elseif ($format == 'datemax' and !$done_this) { _wpl_import('libraries.render'); if (trim($value) != '') { $value = wpl_render::derender_date($value); $query .= " AND DATE(`" . $table_column . "`) <= '" . $value . "'"; } $done_this = true; } elseif ($format == 'rawdatemin' and !$done_this) { if (trim($value) != '') { $query .= " AND DATE(`" . $table_column . "`) >= '" . $value . "'"; } $done_this = true; } elseif ($format == 'rawdatemax' and !$done_this) { if (trim($value) != '') { $query .= " AND DATE(`" . $table_column . "`) <= '" . $value . "'"; } $done_this = true; } elseif ($format == 'gallery' and !$done_this) { if ($value != '-1' and trim($value) != '') {