public function update($experienceId, $data)
{
$query = '
DELETE pab, pad, paf, pai, pam, pas, pat, pav,
pcm, pmm, ptm, pp, pfm
FROM products AS `p`
LEFT JOIN product_attributes_boolean AS `pab` ON pab.product_id = p.`id`
LEFT JOIN product_attributes_date AS `pad` ON pad.product_id = p.`id`
LEFT JOIN product_attributes_float AS `paf` ON paf.product_id = p.`id`
LEFT JOIN product_attributes_integer AS `pai` ON pai.product_id = p.`id`
LEFT JOIN product_attributes_multiselect AS `pam` ON pam.product_id = p.`id`
LEFT JOIN product_attributes_singleselect AS `pas` ON pas.product_id = p.`id`
LEFT JOIN product_attributes_text AS `pat` ON pat.product_id = p.`id`
LEFT JOIN product_attributes_varchar AS `pav` ON pav.product_id = p.`id`
LEFT JOIN product_curator_map AS `pcm` ON pcm.product_id = p.`id`
LEFT JOIN product_media_map AS `pmm` ON pmm.product_id = p.`id`
LEFT JOIN product_tag_map AS `ptm` ON ptm.product_id = p.`id`
LEFT JOIN product_pricing AS `pp` ON pp.`product_id` = p.`id`
LEFT JOIN product_flag_map AS `pfm` ON pfm.`product_id` = p.`id`
WHERE p.id = ?
';
//LEFT JOIN products AS `padd` ON padd.`product_parent_id` = p.`id`
DB::delete($query, [$experienceId]);
$simpleExperienceUpdateData = ['name' => $data['name'], 'slug' => $data['slug'], 'status' => $data['status'], 'type' => 'simple'];
if ($data['status'] === 'Publish' && isset($data['publish_date'])) {
$simpleExperienceInsertData['publish_time'] = $data['publish_date'] . ' ' . $data['publish_time'];
}
DB::table('products')->where('id', $experienceId)->update($simpleExperienceUpdateData);
$productTypeId = DB::table('product_types')->where('slug', 'experiences')->pluck('id');
if (!empty($data['attributes'])) {
$AttributesSaved = $this->saveAttributes($experienceId, $productTypeId, $data['attributes']);
if ($AttributesSaved['status'] !== 'success') {
$AttributesSaved['message'] = 'Could not create the Simple Experience Attributes. Contact the system admin';
return $AttributesSaved;
}
}
$listing_image = $data['media']['listing_image'];
$gallery_images = $data['media']['gallery_images'];
$mobile_listing_images = $data['media']['mobile'];
if (empty($listing_image)) {
$listing_image_array = isset($data['old_media']['listing_image']) && $data['old_media']['listing_image'] != "" ? $data['old_media']['listing_image'] : '';
} else {
$listing_image_array = $data['media']['listing_image'];
}
if ($gallery_images[0] == "") {
$gallery_image_array = isset($data['old_media']['gallery_images']) && $data['old_media']['gallery_images'] != "" ? $data['old_media']['gallery_images'] : '';
} else {
$gallery_image_array = $data['media']['gallery_images'];
}
if (empty($mobile_listing_images)) {
$mobile_listing_image_array = isset($data['old_media']['mobile']) && $data['old_media']['mobile'] != "" ? $data['old_media']['mobile'] : '';
} else {
$mobile_listing_image_array = $data['media']['mobile'];
}
$new_media['media'] = ['listing_image' => $listing_image_array, 'gallery_images' => $gallery_image_array, 'mobile' => $mobile_listing_image_array];
//echo "<pre>"; print_r($new_media['media']); die;
if (!empty($new_media['media']) && !empty($new_media['media']['listing_image']) && (!empty($new_media['media']['gallery_images']) && $new_media['media']['gallery_images'][0] != "") && !empty($new_media['media']['mobile'])) {
$mediaSaved = $this->saveMedia($experienceId, $new_media['media']);
if ($mediaSaved['status'] !== 'success') {
$mediaSaved['message'] = 'Could not create the Simple Experience Media. Contact the system admin';
return $mediaSaved;
}
}
if (!empty($data['pricing'])) {
$pricingSaved = $this->savePricing($experienceId, $data['pricing']);
if ($pricingSaved['status'] !== 'success') {
$pricingSaved['message'] = 'Could not create the Simple Experience Pricing. Contact the system admin';
return $pricingSaved;
}
}
if (!empty($data['addons'])) {
$experinceAddons = new ExperienceAddons();
$addonsSaved = $experinceAddons->create($experienceId, $productTypeId, $data['addons']);
if ($addonsSaved['status'] !== 'success') {
$addonsSaved['message'] = 'Could not map the Simple Experience Addons. Contact the system admin';
return $addonsSaved;
}
}
if (!empty($data['tags'])) {
$tagMapping = $this->mapTags($experienceId, $data['tags']);
if ($tagMapping['status'] !== 'success') {
$tagMapping['message'] = 'Could not map the Simple Experience Tags. Contact the system admin';
return $tagMapping;
}
}
if (!empty($data['curators']) && $data['curators'] != " ") {
//echo "in";
/*$curatorMapping = $this->mapCurator($experienceId, $data['curators']);
if($curatorMapping['status'] !== 'success'){
$curatorMapping['message'] = 'Could not map the Simple Experience curators. Contact the system admin';
return $curatorMapping;
}*/
}
//echo "out"; die;
if (!empty($data['flags'])) {
$flagMapping = $this->mapFlags($experienceId, $data['flags']);
if ($flagMapping['status'] !== 'success') {
$flagMapping['message'] = 'Could not map the Simple Experience Flags. Contact the system admin';
return $flagMapping;
}
}
DB::commit();
return ['status' => 'success'];
}
public function update($experienceId, $data)
{
$query = '
DELETE pab, pad, paf, pai, pam, pas, pat, pav, pcm, pmm, ptm, padd, pfm
FROM products AS `p`
LEFT JOIN product_attributes_boolean AS `pab` ON pab.product_id = p.`id`
LEFT JOIN product_attributes_date AS `pad` ON pad.product_id = p.`id`
LEFT JOIN product_attributes_float AS `paf` ON paf.product_id = p.`id`
LEFT JOIN product_attributes_integer AS `pai` ON pai.product_id = p.`id`
LEFT JOIN product_attributes_multiselect AS `pam` ON pam.product_id = p.`id`
LEFT JOIN product_attributes_singleselect AS `pas` ON pas.product_id = p.`id`
LEFT JOIN product_attributes_text AS `pat` ON pat.product_id = p.`id`
LEFT JOIN product_attributes_varchar AS `pav` ON pav.product_id = p.`id`
LEFT JOIN product_curator_map AS `pcm` ON pcm.product_id = p.`id`
LEFT JOIN product_media_map AS `pmm` ON pmm.product_id = p.`id`
LEFT JOIN product_tag_map AS `ptm` ON ptm.product_id = p.`id`
LEFT JOIN products AS `padd` ON padd.`product_parent_id` = p.`id`
LEFT JOIN product_flag_map AS `pfm` ON pfm.`product_id` = p.`id`
WHERE p.id = ?
';
DB::delete($query, [$experienceId]);
$complexExperienceInsertData = ['name' => $data['name'], 'slug' => $data['slug'], 'status' => $data['status'], 'type' => 'complex'];
if ($data['status'] === 'Publish' && isset($data['publish_date'])) {
$complexExperienceInsertData['publish_time'] = $data['publish_date'] . ' ' . $data['publish_time'];
}
DB::table('products')->where('id', $experienceId)->update($complexExperienceInsertData);
$productTypeId = DB::table('product_types')->where('slug', 'experiences')->pluck('id');
if (!empty($data['attributes'])) {
$AttributesSaved = $this->saveAttributes($experienceId, $productTypeId, $data['attributes']);
if ($AttributesSaved['status'] !== 'success') {
$AttributesSaved['message'] = 'Could not create the Complex Experience Attributes. Contact the system admin';
return $AttributesSaved;
}
}
if (!empty($data['media'])) {
$mediaSaved = $this->saveMedia($experienceId, $data['media']);
if ($mediaSaved['status'] !== 'success') {
$mediaSaved['message'] = 'Could not create the Complex Experience Media. Contact the system admin';
return $mediaSaved;
}
}
if (!empty($data['addons'])) {
$experinceAddons = new ExperienceAddons();
$addonsSaved = $experinceAddons->create($experienceId, $productTypeId, $data['addons']);
if ($addonsSaved['status'] !== 'success') {
$addonsSaved['message'] = 'Could not map the Complex Experience Addons. Contact the system admin';
return $addonsSaved;
}
}
if (!empty($data['tags'])) {
$tagMapping = $this->mapTags($experienceId, $data['tags']);
if ($tagMapping['status'] !== 'success') {
$tagMapping['message'] = 'Could not map the Complex Experience Tags. Contact the system admin';
return $tagMapping;
}
}
if (!empty($data['curator'])) {
$curatorMapping = $this->mapCurator($experienceId, $data['curator']);
if ($curatorMapping['status'] !== 'success') {
$curatorMapping['message'] = 'Could not map the Complex Experience curators. Contact the system admin';
return $curatorMapping;
}
}
if (!empty($data['curators'])) {
$flagMapping = $this->mapFlags($experienceId, $data['flags']);
if ($flagMapping['status'] !== 'success') {
$flagMapping['message'] = 'Could not map the Complex Experience Flags. Contact the system admin';
return $flagMapping;
}
}
DB::commit();
return ['status' => 'success'];
}
