function do_save_new_schedules($f3, $args) { $allData = json_decode(f3()->get('SESSION.uploadPrograms'), true); db()->begin(); foreach ($allData['schedules'] as $prog) { $program = Program::get_program_by_codename($prog['c']); if (empty($program)) { $program['title'] = $prog['c']; $program['uri'] = ''; $program['id'] = 0; } db()->exec("INSERT INTO `" . tpf() . "schedules`(`title`, `uri`, `program_id`, `start_date`, `end_date`, `status`, `last_ts`, " . "`last_user`, `insert_user`, `insert_ts`) VALUES ('" . $program['title'] . "', '" . $program['uri'] . "', '" . $program['id'] . "', '" . $prog['d'] . " " . $prog['s'] . ":00', '" . $prog['d'] . " " . $prog['e'] . ":00', 'Yes', '" . date('Y-m-d H:i:s') . "', '" . rStaff::_CStaff('id') . "', '" . rStaff::_CStaff('id') . "', '" . date('Y-m-d H:i:s') . "')"); } db()->commit(); return parent::_return(1, $allData['schedules']); }
static function load_zipcodes($county) { $rows = db()->exec("SELECT `zipcode`, `town`, CONCAT(`county`, `town`) AS `full_name` FROM `" . tpf() . self::ZIPCODETB . "` WHERE `county`= ? ORDER BY `zipcode`", $county); return $rows; }