Example #1
0
 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;
 }
Example #2
0
        }
        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;
Example #3
0
        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) != '') {