public function ajax_appointments()
{
$data = $this->parse_input_data();
$response = array();
if ($this->type === 'GET') {
$response = $this->models->get_all_appointments($data);
}
die(json_encode($response));
}
public function ajax_export()
{
$data = $this->parse_input_data();
$workersTmp = $response = $this->models->get_all_rows('ea_staff');
$locationsTmp = $response = $this->models->get_all_rows('ea_locations');
$servicesTmp = $response = $this->models->get_all_rows('ea_services');
$workers = array();
$locations = array();
$services = array();
foreach ($workersTmp as $w) {
$workers[$w->id] = $w->name;
}
foreach ($locationsTmp as $l) {
$locations[$l->id] = $l->name;
}
foreach ($servicesTmp as $s) {
$services[$s->id] = $s->name;
}
// print_r($workersTmp);die;
header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename=Customers_Export.csv');
echo "";
// UTF-8 BOM
// set_time_limit(0);
$params = array('from' => $data['ea-export-from'], 'to' => $data['ea-export-to']);
$rows = $this->models->get_all_appointments($params);
$out = fopen('php://output', 'w');
if (count($rows) > 0) {
$arr = get_object_vars($rows[0]);
$keys = array_keys($arr);
fputcsv($out, $keys);
}
foreach ($rows as $row) {
$arr = get_object_vars($row);
$arr['worker'] = $workers[$arr['worker']];
$arr['location'] = $locations[$arr['location']];
$arr['service'] = $services[$arr['service']];
fputcsv($out, $arr);
}
fclose($out);
die;
}
