/**
* undocumented function
*
* @return void
* @author
**/
public static function isExist($id)
{
$count = SocialAction::where('social_action_category_id', $id)->count();
if ($count > 0) {
return true;
}
return false;
}
/**
* undocumented function
*
* @return void
* @author
**/
public static function isExist($id)
{
$count1 = SocialTarget::where('city_id', $id)->count();
$count2 = SocialAction::where('city_id', $id)->count();
$count3 = Events::where('city_id', $id)->count();
$count4 = User::where('city_id', $id)->count();
$count = $count1 + $count2 + $count3 + $count4;
if ($count > 0) {
return true;
}
return false;
}
public static function UpdateSocialAction($input)
{
$rules = array('name' => 'required', 'description' => 'required|min:5', 'stewardship' => 'required|min:5', 'bank_account_description' => 'required|min:5', 'currency' => 'required', 'total_donation_target' => 'required', 'expired_at' => 'required');
$validator = Validator::make($input, $rules);
if ($validator->fails()) {
return $validator->errors()->all();
} else {
$id = $input['id'];
unset($input['id']);
if (!empty($input['expired_at'])) {
$started_at = preg_split("/([\\/: ])/", $input['expired_at']);
$input['expired_at'] = mktime((int) $started_at[3], (int) $started_at[4], 0, (int) $started_at[0], (int) $started_at[1], (int) $started_at[2]);
} else {
$input['expired_at'] = '';
}
$getSlug = SocialAction::where('id', $id)->first();
$slug = Str::slug($input['name']);
// jika input tidak sama dengan slug di database
if (strcmp($input['name'], $getSlug['name']) != 0) {
$checkSlug = SocialAction::where('slug', $slug)->where('id', '!=', $id)->count();
if ($checkSlug > 0) {
$input['slug'] = $slug . "-" . $id;
} else {
$input['slug'] = $slug;
}
}
$photo = Photo::updateAvatar($getSlug['cover_photo_id'], 'social_actions', $getSlug->id);
$input['cover_photo_id'] = $photo['cover_photo_id'];
$SocialAction = SocialAction::find($id);
$SocialAction->fill($input);
$SocialAction->save();
return "ok";
}
}
/**
* undocumented function
*
* @return void
* @author
**/
public function deleteDo()
{
$id = Input::get('id');
$photo = Photo::remove($id);
// Mengupdate semua fitur yang menggunakan foto menjadi 0
Events::where('default_photo_id', $id)->update(['default_photo_id' => 0]);
Events::where('cover_photo_id', $id)->update(['cover_photo_id' => 0]);
SocialAction::where('default_photo_id', $id)->update(['default_photo_id' => 0]);
SocialAction::where('cover_photo_id', $id)->update(['cover_photo_id' => 0]);
SocialTarget::where('default_photo_id', $id)->update(['default_photo_id' => 0]);
SocialTarget::where('cover_photo_id', $id)->update(['cover_photo_id' => 0]);
if ($photo) {
$lokasi = public_path() . '/photos/';
if (unlink($lokasi . $id . '.jpg') && unlink($lokasi . 'thumb_' . $id . '.jpg')) {
return Redirect::route('admin.photo')->withStatuses(['delete' => 'Hapus Sukses']);
}
return Redirect::route('admin.photo')->withErrors(['delete' => 'Delete File Gagal']);
}
return Redirect::route('admin.photo')->withErrors(['delete' => 'Delete File Gagal']);
}
public function update($id)
{
$data = array('menu' => 'Aksi Sosial', 'title' => 'Aksi Sosial', 'description' => '', 'breadcrumb' => array('Kategori Aksi Social' => route('admin.social-action')));
if (!Session::has('time') && (!Session::has('validasi') && Session::get('validasi') != 'social_actions')) {
$time = time();
Session::put('time', $time);
}
$social_action = SocialAction::where('id', $id)->first();
$data['action'] = 'admin.social-action.update.post';
$data['social_action'] = $social_action;
$data['social_target'] = SocialTarget::all();
$data['social_action_category'] = SocialActionCategory::all();
$data['user'] = User::all();
$data['city'] = City::all();
// Get Photos that related with this
$data['photos'] = Photo::where('type_name', '=', 'social_actions')->where('type_id', '=', $social_action->id)->orderBy('id', 'desc')->get();
return View::make('admin.pages.social-action.create')->with($data);
}
