/** * Saves the pool to the database. * * @param \MusicBox\Entity\Like $pool */ public function save($pool) { $poolData = array('address_id' => $pool->getAddress()->getId(), 'access_info' => $pool->getAccessInfo()); if ($pool->getId()) { $this->db->update('pools', $poolData, array('pool_id' => $pool->getId())); $newFile = $this->handleFileUpload($item); if ($newFile) { $poolData['image'] = $pool->getImage(); } } else { // The pool is new, note the creation timestamp. $poolData['created_at'] = time(); $this->db->insert('pools', $poolData); // Get the id of the newly created pool and set it on the entity. $id = $this->db->lastInsertId(); $pool->setId($id); // If a new image was uploaded, update the pool with the new // filename. $newFile = $this->handleFileUpload($pool); if ($newFile) { $newData = array('image' => $pool->getImage()); $this->db->update('pools', $newData, array('pool_id' => $id)); } } }
/** * Saves the like to the database. * * @param \MusicBox\Entity\Like $like */ public function save($like) { $likeData = array('artist_id' => $like->getArtist()->getId(), 'user_id' => $like->getUser()->getId()); if ($like->getId()) { $this->db->update('likes', $likeData, array('like_id' => $like->getId())); } else { // The like is new, note the creation timestamp. $likeData['created_at'] = time(); $this->db->insert('likes', $likeData); // Get the id of the newly created like and set it on the entity. $id = $this->db->lastInsertId(); $like->setId($id); } }
/** * Saves the group to the database. * * @param \MusicBox\Entity\Like $group */ public function save($group) { $groupData = array('artist_id' => $group->getArtist()->getId(), 'user_id' => $group->getUser()->getId()); if ($group->getId()) { $this->db->update('groups', $groupData, array('group_id' => $group->getId())); } else { // The group is new, note the creation timestamp. $groupData['created_at'] = time(); $this->db->insert('groups', $groupData); // Get the id of the newly created group and set it on the entity. $id = $this->db->lastInsertId(); $group->setId($id); } }
/** * Saves the lesson to the database. * * @param \MusicBox\Entity\Like $lesson */ public function save($lesson) { $lessonData = array('user_id' => $lesson->getUser()->getId()); if ($lesson->getId()) { $this->db->update('lessons', $lessonData, array('lesson_id' => $lesson->getId())); } else { // The lesson is new, note the creation timestamp. $lessonData['created_at'] = time(); $this->db->insert('lessons', $lessonData); // Get the id of the newly created lesson and set it on the entity. $id = $this->db->lastInsertId(); $lesson->setId($id); } }
/** * Saves the address to the database. * * @param \MusicBox\Entity\Like $address */ public function save($address) { $addressData = array('user_id' => $address->getUserId(), 'street' => $address->getStreet(), 'street2' => $address->getStreet2(), 'city' => $address->getCity(), 'state' => $address->getState(), 'zip' => $address->getZip(), 'billing' => $address->getType()); if ($address->getId()) { try { $this->db->update('addresses', $addressData, array('address_id' => $address->getId())); } catch (\Exception $e) { return false; } } else { // The address is new, note the creation timestamp. try { $this->db->insert('addresses', $addressData); // Get the id of the newly created address and set it on the entity. $id = $this->db->lastInsertId(); $address->setAddressId($id); } catch (\Exception $e) { dump($e); exit; return false; } } }