public function actionProfile() { $model = new Restaurants('profile'); if (isset($_POST['Restaurants'])) { $_POST['Restaurants']['modified_date'] = date('Y-m-d H:i:s'); $_POST['Restaurants']['id'] = Yii::app()->user->getId(); $result = $model->updateRestaurantProfile($_POST['Restaurants'], $_FILES['Restaurants']); } $restaurant = $model->getRestaurantById(Yii::app()->user->getId()); $this->render('profile', array('model' => $model, 'restaurant' => $restaurant['result'])); }
function createRestaurantBooking($bean, $nhahang = '') { global $db; $sql = "\r\n SELECT \r\n a.id \r\n FROM\r\n `restaurantbookings` a \r\n JOIN `restaurantsrantbookings_c` b \r\n ON a.`id` = b.`restaurantd663ookings_idb` \r\n AND b.`deleted` = 0 \r\n AND b.`restaurant437baurants_ida` = '{$nhahang->nh_id}' \r\n JOIN `groupprograrantbookings_c` c \r\n ON c.`groupprogre72bookings_idb` = a.`id` \r\n AND c.`deleted` = 0 \r\n AND c.`groupprogr880erograms_ida` = '{$bean->id}' \r\n WHERE a.`deleted` = 0 \r\n "; $RestaurantBooking = new RestaurantBookings(); $result = $db->query($sql); while ($row = $db->fetchByAssoc($result)) { $RestaurantBooking->id = $row['id']; } $RestaurantBooking->groupprogratbookings_name = $bean->groupprogram_code; $RestaurantBooking->groupprogr880erograms_ida = $bean->id; $restaurant = new Restaurants(); $restaurant->retrieve($nhahang->nh_id); $RestaurantBooking->restaurant437baurants_ida = $restaurant->id; $RestaurantBooking->restaurantstbookings_name = $restaurant->name; $RestaurantBooking->res_address = $restaurant->address; $RestaurantBooking->res_tel = $restaurant->tel; $RestaurantBooking->res_fax = $restaurant->fax; $RestaurantBooking->confirm = 0; $RestaurantBooking->name = 'Restaurant Bookings To ' . $restaurant->name; $RestaurantBooking->assigned_user_name = $bean->assigned_user_name; $RestaurantBooking->assigned_user_id = $bean->assigned_user_id; $return = $RestaurantBooking->save(); return $return; }