33
loading...
This website collects cookies to deliver better user experience
Lib | Version | Use |
---|---|---|
dropzone.min.js | ^5.9.3 | Multi drop images |
Sortable.js | ^* | Sort dropzone instances |
select2.min.js | ^4.0.13 | For multiselect |
jquery.js | ^0.3.1 | simple add/remove items from dom |
UPDATE db.channels
SET image = CASE
WHEN id = 86 THEN "AETV"
WHEN id = 56 THEN "AHC"
END
WHERE ID IN (86, 56)
function upload(Request $request)
{
$images = $request->file('file');
// dump($images);
// $filenameArr=$request->filenames;
$customnameArr=$request->description;
$keys = array_keys( $customnameArr );
$size = sizeof($images);
// dump($customnameArr);
$ids = [];
$cases = [];
$params = [];
for($x = 0; $x < $size; $x++ ) {
$toFilename = $customnameArr[$keys[$x]].'.'.$images[$x]->extension();
// echo "<br>";
// echo "key: ". $keys[$x] . ", value: ". $customnameArr[$keys[$x]] . "\n";
$images[$x]->move(public_path('/uploads/channellogo'), $toFilename);
$cases[] = "WHEN {$keys[$x]} then ?";
$ids[] = $keys[$x];
$params[] = $toFilename;
}
$ids = implode(',', $ids);
$cases = implode(' ', $cases);
if (!empty($ids)) {
// UPDATE db.channels
// SET image = CASE
// WHEN id = 86 THEN "AETV"
// WHEN id = 56 THEN "AHC"
// END
// WHERE ID IN (86, 56)
\DB::update("UPDATE channels SET `image` = CASE `id` {$cases} END WHERE `id` in ({$ids})", $params);
return response()->json(['success' => "Images uploaded"]);
}
}