/**
* Execute the job.
*
* @param Request $request
*/
public function handle(Request $request)
{
$insertQuery = [];
//preview images
for ($i = 1; $i <= $this->count; $i++) {
$fileName = $this->saveCroppedImage($request, $i);
//DELETE COLOUR IMAGES THAT ARE BEING DELETED IN CMS
$delete_colour_image_ids = $request->get("delete_colour_images");
if ($delete_colour_image_ids) {
$delete_colour_image_ids_array = explode(",", $delete_colour_image_ids);
ProductPhoto::whereIn("id", $delete_colour_image_ids_array)->delete();
}
$edit_image_id = $request->get("edit_colour_img_" . $i);
if ($edit_image_id) {
$product_photo = ProductPhoto::find($edit_image_id);
if ($fileName) {
$product_photo->img = $fileName;
$product_photo->is_colour_img = 1;
$this->product->product_photos()->save($product_photo);
DB::table('photos_colours')->where("photo_id", "=", $product_photo->id)->update(['photo_id' => $product_photo->id, 'colour_id' => (int) $request->get("product_colour_code_input_" . $i)]);
}
} else {
$product_photo = new ProductPhoto();
if ($fileName) {
$product_photo->img = $fileName;
$product_photo->is_colour_img = 1;
$this->product->product_photos()->save($product_photo);
$insertQuery[] = ['photo_id' => $product_photo->id, 'colour_id' => (int) $request->get("product_colour_code_input_" . $i)];
}
}
}
if (count($insertQuery) > 0) {
DB::table('photos_colours')->insert($insertQuery);
}
// dd("STOP");
}
