function convert_datetime_to_vn($date_time_us)
{
$p = explode(' ', $date_time_us);
if (count($p) != 2) {
return NULL;
}
return convert_date_to_vn($p[0]) . ' ' . $p[1];
}
public function findRelated($promo_date, $seo_url)
{
$sql = 'SELECT seo_url, subject, promo_date FROM promos WHERE promo_date <= ? AND seo_url <> ? ' . 'ORDER BY promo_date DESC LIMIT 0, 10';
$ps = new PreparedStatement($sql);
$ps->setString(1, $this->ds->escape(convert_date_to_us($promo_date)));
$ps->setString(2, $this->ds->escape($seo_url));
$rs = $this->ds->execute($ps->getSql());
$list_promo = array();
while ($row = mysql_fetch_array($rs)) {
$list_promo[] = array('seo_url' => $row['seo_url'], 'promo_date' => convert_date_to_vn($row['promo_date']), 'subject' => htmlspecialchars($row['subject']));
}
mysql_free_result($rs);
return $list_promo;
}
function findByAll()
{
$sql = 'SELECT P.id, full_name, birthday, P.phone, ' . '(SELECT name FROM cities AS Q WHERE Q.id = P.city_id) AS city_name ' . 'FROM customers AS P ' . 'ORDER BY P.id';
$rs = $this->ds->execute($sql);
$list_cust = array();
while ($row = mysql_fetch_array($rs)) {
$id = (int) $row['id'];
$list_cust[$id] = array('full_name' => htmlspecialchars($row['full_name']), 'birthday' => convert_date_to_vn($row['birthday']), 'city_name' => htmlspecialchars($row['city_name']), 'phone' => htmlspecialchars($row['phone']));
}
mysql_free_result($rs);
return $list_cust;
}
