function getCheckunsafeupdate($id = '', $unsafe_id = '') { $startDate = date("Y-m-d H:i:s"); $endDate = date("Y-m-d H:i:s", strtotime('-24 hours')); if ($id == "") { $project_update = ProjectUpdates::where('updated_at', '>=', $endDate)->get(); } else { $project_update = ProjectUpdates::where('id', '>=', $id)->get(); } //dd("C"); $titles = NULL; $description = NULL; $new_search = NULL; $getUnsafewords = 0; for ($i = 0; $i < count($project_update); $i++) { $titles = $project_update[$i]['title']; // change with your field $description = $project_update[$i]['description']; // change with your field $new_search = $titles . " , " . $description; $getUnsafewords = $this->getUnsafewords($new_search); if ($getUnsafewords == 1) { if ($id == "") { $unsafeDetails = ProjectUpdates::findOrFail($project_update[$i]['id']); $unsafe = new Unsafe(); $unsafe->post_id = $project_update[$i]['id']; $unsafe->user_id = $project_update[$i]['user_id']; $unsafe->type = "updates"; // add table name $unsafe->status = 1; $unsafe->notified = 0; //getCheckduplicate(unique id for update/comment,table name) //return true or false $getCheckduplicate = $this->getCheckduplicate($project_update[$i]['id'], 'updates'); if ($getCheckduplicate) { $unsafe->save(); } } else { $update = ProjectUpdates::where('id', '=', $id)->update(array('status' => '2')); $updateUnsafe = Unsafe::where('id', '=', $unsafe_id)->update(array('notified' => '2')); } } } }
public function postPedit($id, $update_title, $update_text) { $project_update = ProjectUpdates::findOrFail($id); $project_update->title = $update_title; $project_update->description = $update_text; $project_update->status = 1; $userProfile = Profile::where('user_id', Auth::id())->first(); if ($id == '' || $update_text == '' || $update_title == '') { echo "An error occurred. Please try again later"; die; } if ($project_update->save()) { echo $id; /*echo '<div class="update_listing"> <div class="update_image"><img src="'.url().'/images/avtar-image/'.$userProfile['user_avtar'].'" alt="Reminder icon" width="50" border="0" ></div> <div class="update_text"> <p><span>'.$update_title.'</span> - just now</p> '.$update_text.' </div> </div><div class="clear"></div>';*/ } }