1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
| function getListing($id='all', $addOnSQL="", $sellerid="", $sort="")
{
global $use_listing_approval;
$approved = '';
$count = '';
if (empty($sort))
$sort = "ORDER BY added_on DESC";
if ($use_listing_approval) {
if (!isset($_SESSION["admin"])) {
if (isset($_SESSION["seller"])) {
if ($sellerid == getSellerId($_SESSION["user"])) {
$approved = "";
}
} else {
if (!empty($id) && empty($addOnSQL) && $id == 'all') {
$approved = "WHERE approved = 1";
} else {
$approved = "approved = 1 AND ";
}
}
}
}
if (!empty($id) && $id == "all" || !empty($addOnSQL) && $id == 'search') {
//smarty paginate class used for users list in admin and also vehicle listings
$paginate = new SmartyPaginate();
//set the result query from listing number set
$result_set_start = $paginate->getCurrentIndex();
//set the result max query number
$result_set_max = $paginate->getLimit();
$page_limits = "LIMIT $result_set_start, $result_set_max";
}
if (!empty($id) && empty($addOnSQL) && $id == 'all') {
$sql = "SELECT DATE_FORMAT(added_on,'%d/%m/%Y') AS added_on, FROM listings $approved $sort $page_limits";
$count = "SELECT COUNT(id) FROM listings $approved $sort";
} elseif (!empty($addOnSQL) && $id == 'search') {
$sql = "SELECT DATE_FORMAT(added_on,'%d/%m/%Y') AS added_on, FROM listings WHERE $approved $addOnSQL $sort $page_limits";
$count = "SELECT COUNT(id) FROM listings WHERE $approved $addOnSQL $sort";
} else {
$sql = "SELECT DATE_FORMAT(added_on,'%d/%m/%Y') AS added_on, FROM listings WHERE id = " . $id . "";
}
if ($count) {
$count_res = sqlQuery($count); if(sqlErrorReturn()) sqlDebug(__FILE__,__LINE__,sqlErrorReturn());
$row_count = sqlFetchRow($count_res);
sqlFreeResult($count_res);
}
$res = sqlQuery($sql); if(sqlErrorReturn()) sqlDebug(__FILE__,__LINE__,sqlErrorReturn());
$c=0;
while ($a_row = sqlFetchArray($res)) {
$records[$c]["id"] = $a_row["id"];
$records[$c]["approved"] = $a_row["approved"];
$records[$c]["country"] = $a_row["country"];
$records[$c]["state"] = $a_row["state"];
$records[$c]["city"] = $a_row["city"];
$records[$c]["address"] = $a_row["address"];
$records[$c]["zip"] = $a_row["zip"];
$records[$c]["sellerid"] = $a_row["sellerid"];
$records[$c]["seller"] = $a_row["seller"];
$records[$c]["added_on"] = $a_row["added_on"];
$records[$c]["last_updated"] = $a_row["last_updated"];
$records[$c]["hitcount"] = $a_row["hitcount"];
$records[$c]["images"] = getListImages($a_row["id"]);
++$c;
}
sqlFreeResult($res);
if (!empty($id) && $id == "all" || !empty($addOnSQL) && $id == 'search') {
//set total row count to count from query else defaults to 0
$paginate->setTotal(!empty($row_count['0']) ? $row_count['0'] : 0);
if (!empty($records)) {
//return array_slice($records, $paginate->getCurrentIndex(), $paginate->getLimit());
return $records;
}
} elseif (isset($records)) {
return $records;
}
} |
Partager