public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `a`.`id`,`a`.`name`,`a`.`uid`,`b`.`name` AS `type`, `a`.`tel`, `a`.`fax`, `a`.`www`, `a`.`email`, `a`.`VAT_number` \n\t\t\t\t\t\tFROM `" . $this->table() . "` `a` \n\t\t\t\t\t\tLEFT JOIN `" . $this->table() . "_type` AS `b` ON (`a`.`entity_type_id`=`b`.`id`) ";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>0 AND `b`.`deleted`=0) AND (" . $filter . ")";
list($list, $fields) = parent::_ls($sql, $filter, $sort, $limit);
$list = $this->ls_numeric($list, array("uid"));
return array($list, $fields);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT \tDATE_FORMAT(`a`.`date`,'%Y-%m-%d') AS `date`, \n\t\t\t\t\t\t`a`.`id`,\n\t\t\t\t\t\t`a`.`type`, \n\t\t\t\t\t\tCONCAT(`a`.`uid_prefix`,`a`.`uid`) `uid`, \n\t\t\t\t\t\t`b`.`name` as `entity`, \n\t\t\t\t\t\t`a`.`reference`,\n\t\t\t\t\t\t`a`.`account`, \n\t\t\t\t\t\tIF(`a`.`satisfied`>0,'" . YES . "','" . NO . "') AS `satisfied`,\n\t\t\t\t\t\tIF(`a`.`satisfied`>0,'n/a',IF(`a`.`deadline`>-1,IF((UNIX_TIMESTAMP()-UNIX_TIMESTAMP(DATE_ADD(`a`.`date`, INTERVAL `a`.`deadline` DAY)))>0,'" . YES . "','" . NO . "'),'" . NO . "')) AS `overdue`\n\t\t\t\t\tFROM `" . $this->table() . "`AS `a` \n\t\t\t\t\t\tLEFT JOIN `##_SPACE_entity` AS `b` ON (`a`.`entity_id`=`b`.`id`) ";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>0 AND `b`.`deleted`=0) AND (" . $filter . ")";
list($list, $fields) = parent::_ls($sql, $filter, $sort, $limit);
$list = $this->ls_numeric($list, array("uid"));
return array($list, $fields);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `id`,`name`,`description` FROM `" . $this->table() . "`";
$filter = "(`deleted`=0 AND `id`>0) AND (" . $filter . ")";
list($list, $fields) = parent::_ls($sql, $filter, $sort, $limit);
$list = $this->ls_numeric($list, array("uid"));
return array($list, $fields);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `a`.`id`,`a`.`name`, `a`.`sku`, `d`.`sign` AS `currency`, `a`.`indicative_price` AS `price`, `c`.`name` AS `vat`, `b`.`name` AS `type`\n\t\t\t\t\tFROM `" . $this->table() . "`AS `a` \n\t\t\t\t\tLEFT JOIN `" . $this->table() . "_type` AS `b` ON (`a`.`inventory_type_id`=`b`.`id` AND `b`.`deleted`=0) \n\t\t\t\t\tLEFT JOIN `##_SPACE_vat` AS `c` ON (`a`.`indicative_vat_id`=`c`.`id`)\n\t\t\t\t\tLEFT JOIN `##_SPACE_currency` AS `d` ON (`a`.`indicative_currency_id`=`d`.`id`)";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>0 AND `b`.`deleted`=0 AND `c`.`deleted`=0 AND `d`.`deleted`=0) AND (" . $filter . ")";
list($list, $fields) = parent::_ls($sql, $filter, $sort, $limit);
$list = $this->ls_money($list, array("price"));
return array($list, $fields);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `a`.`id`, CONCAT(`a`.`reference_prefix`,`a`.`reference`) `reference`, `a`.`description`,`b`.`name` AS `customer`, DATE_FORMAT(`a`.`date`,'%Y-%m-%d') AS `date`, IF(`a`.`purchased`>0,'" . YES . "','" . NO . "') AS `purchased`\n\t\t\t\t\tFROM `" . $this->table() . "`AS `a` \n\t\t\t\t\tLEFT JOIN `##_SPACE_entity` AS `b` ON (`a`.`entity_id`=`b`.`id`) ";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>0 AND `b`.`deleted`=0) AND (" . $filter . ")";
return parent::_ls($sql, $filter, $sort, $limit);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `a`.`id`,`a`.`name`, `a`.`description`\n\t\t\t\t\tFROM `" . $this->table() . "` AS `a`";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>=0) AND (" . $filter . ")";
return parent::_ls($sql, $filter, $sort, $limit);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `a`.`id`, `a`.`name`,`a`.`login`, `a`.`email`, `a`.`type`, `b`.`name` AS `language`, IF(STRCMP(`a`.`last_login`,'0000-00-00 00:00:00'),DATE_FORMAT(`a`.`last_login`,'%Y-%m-%d @ %k:%i:%s'),'" . NEVER . "') AS `last_login`\n\t\t\t\t\tFROM `" . $this->table() . "`AS `a` \n\t\t\t\t\tLEFT JOIN `##_language` AS `b` ON (`b`.`id`=`a`.`language_id` AND `b`.`deleted`=0)";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>=0 AND `b`.`deleted`=0) AND (" . $filter . ")";
return parent::_ls($sql, $filter, $sort, $limit);
}
public function ls($filter = 1, $sort = "", $limit = "")
{
$sql = "SELECT `a`.`id`,`a`.`name`, `a`.`export_to`, `a`.`recurrence`, `b`.`timestamp` AS `last_run`, IF(`b`.`exit_status`=0,'" . RES_SUCCESS . "','" . RES_FAILED . "') AS `exit_status`\n\t\t\t\t\tFROM `" . $this->table() . "` AS `a` \n\t\t\t\t\tLEFT JOIN (SELECT * FROM `" . $this->table() . "_log` ORDER BY `timestamp` DESC LIMIT 0,1) AS `b` ON (`b`.`crontab_id`=`a`.`id`)";
$filter = "(`a`.`deleted`=0 AND `a`.`id`>=0 AND `b`.`deleted`=0) AND (" . $filter . ")";
return parent::_ls($sql, $filter, $sort, $limit);
}
