Ich möchte die Ergebnisse der Summe aus der Datenbank
mit Ajax nach Benutzer „A“ und nach Datum anzeigen
Zeige aber nur das COUNT-Ergebnis (z. B. 4), nicht (z. B. 120,00 $)
Code: Select all
public function ajax_dashboard()
{
date_default_timezone_set($this->setting->timezone);
$date = date("Y-m-d");
$year = date("Y");
$queue = Sale::find('all', array('conditions' => array('status = ?', '0')));;
$onproccess = Sale::find('all', array('conditions' => array('status = ?', '1')));;
$finish = Sale::find('all', array('conditions' => array('status = ?', '2')));;
$unpaid = Sale::find('all', array('conditions' => array('status = ?', '1')));;
$todaysales = Sale::find('all', array('conditions' => array('created_by = ?', 'cashier')=> array('created_at = ?', '$date')));;
$data = array(
"queue" => $queue,
"onproccess" => $onprocess,
"finish" => $finish,
"unpaid" => $unpaid,
"todaysales" => $todaysales
);
echo json_encode($data);
}
Vielen Dank vorher
Mobile version