$swday -> $nwday"; echo(json_encode($return_data)); exit(); } $offset = strtotime("$schedule_start 12:00:00") - strtotime("$first_menu_date 12:00:00"); for ($i = 0; $i < count($menuDates); $i++) { $mdate = $menuDates[$i]['menu_date']; $newdate = date("Y-m-d",strtotime($mdate) + $offset); $menuDates[$i]['menu_date'] = $newdate; } } $schedulesTable = new Table("hotlunch_schedules"); $schedule['school_num'] = $school_num; $schedule['schedule_name'] = $schedule_title; $schedule['sequence'] = intval(db_getVal("SELECT max(sequence) FROM hotlunch_schedules WHERE school_num = $school_num")) + 1; $schedule['start_order_datetime'] = date("Y-m-d H:i:00",strtotime($order_start)); $schedule['end_order_datetime'] = date("Y-m-d H:i:00",strtotime($order_end)); $schedule['schedule_start_date'] = date("Y-m-d",strtotime($schedule_start)); $schedule['supplier_source_school'] = $source_school_num; $query = $schedulesTable->BuildInsert($schedule); db_query($query); $newSchedule = db_insert_id(); $menudatesTable = new Table("hotlunch_menu_dates"); $menuitemsTable = new Table("hotlunch_menu_items"); $menuproductsTable = new Table("hotlunch_menu_products"); $scheduleclassesTable = new Table("hotlunch_schedules_classes"); $menudatesclassesTable = new Table("hotlunch_menu_dates_classes"); $menuitemsclassesTable = new Table("hotlunch_menu_items_classes"); // Copy each menu date to new schedule for ($i = 0; $i < count($menuDates); $i++) { $entry = $menuDates[$i]; $entry['school_num'] = $school_num; $entry['schedule_num'] = $newSchedule; $entry['display'] = 'Y'; $source_menu_num = $entry['record_num']; $query = $menudatesTable->BuildInsert($entry); db_query($query); $newMenu = db_insert_id(); // Get and copy menu items to new menu date $query = "SELECT * FROM hotlunch_menu_items WHERE school_num = $source_school_num AND menu_num = $source_menu_num"; $items = db_query($query); while ($row = db_fetch_assoc($items)) { $source_item_num = $row['record_num']; $row['school_num'] = $school_num; $row['menu_num'] = $newMenu; $query = $menuitemsTable->BuildInsert($row); db_query($query); $newItem = db_insert_id(); // Get and copy menu products to new menu item $query = "SELECT * FROM hotlunch_menu_products WHERE school_num = $source_school_num AND menu_item_num = $source_item_num"; $products = db_query($query); while ($row = db_fetch_assoc($products)) { $row['school_num'] = $school_num; $row['menu_item_num'] = $newItem; $query = $menuproductsTable->BuildInsert($row); db_query($query); } // Process any menu_items_classes if ($school_num == $source_school_num) { $query = "SELECT * FROM hotlunch_menu_items_classes " . "WHERE school_num = $source_school_num " . "AND schedule_num = $source_schedule_num " . "AND menu_num = $source_menu_num " . "AND menu_item_num = $source_item_num"; $results = db_query($query); while ($row = db_fetch_assoc($results)) { $row['school_num'] = $school_num; $row['schedule_num'] = $newSchedule; $row['menu_num'] = $newMenu; $row['menu_item_num'] = $newItem; $query = $menuitemsclassesTable->BuildInsert($row); db_query($query); } } } // Process any menu_dates_classes entries if ($school_num == $source_school_num) { $query = "SELECT * FROM hotlunch_menu_dates_classes " . "WHERE school_num = $source_school_num " . "AND schedule_num = $source_schedule_num " . "AND menu_num = $source_menu_num"; $results = db_query($query); while ($row = db_fetch_assoc($results)) { $row['school_num'] = $school_num; $row['schedule_num'] = $newSchedule; $row['menu_num'] = $newMenu; $query = $menudatesclassesTable->BuildInsert($row); db_query($query); } } } // Process any schedules_classes entries if ($school_num == $source_school_num) { $query = "SELECT * FROM hotlunch_schedules_classes " . "WHERE school_num = $source_school_num " . "AND schedule_num = $source_schedule_num"; $results = db_query($query); while ($row = db_fetch_assoc($results)) { $row['school_num'] = $school_num; $row['schedule_num'] = $newSchedule; $query = $scheduleclassesTable->BuildInsert($row); db_query($query); } } $return_data['ajax_return_code'] = 0; $return_data['ajax_message'] = ""; $return_data['schedule_num'] = $newSchedule; echo(json_encode($return_data)); ?>