function sellNow(Request $request) { if (!Auth::check()) { return Redirect::to('/login'); } if ($request->isMethod('post')) { $rules = array('inc_value' => 'required|numeric', 'char_detail' => 'required', 'title' => 'required', 'charname' => 'required', 'charid' => 'required'); $formData = $request->all(); $validator = Validator::make($formData, $rules); if ($validator->fails()) { return Redirect::to('/mycharacters')->withInput()->withErrors($validator); } $title = trim($request->get('title')); $char_detail = trim($request->get('char_detail')); $charid = trim($request->get('charid')); $inc_value = trim($request->get('inc_value')); $charname = trim($request->get('charname')); $id = Auth::user()->id; $characters = Character::where('uid', "=", $id)->where('char_id', '=', $charid)->first(); //$characters = Character::where('uid', "=",$id)->where('char_id','=',$charid)->get()->take(1); //$charObj = $characters; foreach ($characters as $char_dt) { if ($char_dt['sell_status'] != 0) { return Redirect::to('/bazaar'); } } $row_count = $characters->count(); if (!empty($characters)) { $auction = new Eveapi(); //$auction->uid = $id; //$auction->char_id = $charid; $auction->maintitle = $title; $auction->pilotname = $charname; $auction->lastpost_time = Carbon::now(); $auction->update_status = 1; $auction->page = 1; $auction->status = 0; $auction->save(); $last_inserid = $auction->id; $post_thread = new Evebid(); $post_thread->bid_id = $last_inserid; $post_thread->char_id = $charid; $post_thread->post_rank = 1; $post_thread->post_time = Carbon::now(); $post_thread->update_time = Carbon::now(); $post_thread->wall_post = $char_detail; $post_thread->profile_link = $charid . "_128.jpg"; $post_thread->username = $charname; $post_thread->bid_amount = $inc_value; $post_thread->save(); $characters->sell_status = 1; $characters->save(); } return Redirect::to('/bazaar'); } }
public function insert_detail($post_detail) { $Eveapi = new Eveapi(); $date1 = $post_detail['lastpost_time']; $date = str_replace('.', '-', $date1); //echo strtotime($date1); //echo date('Y-m-d',strtotime($post_detail['lastpost_time'])); $tid = Eveapi::where('threadid', $post_detail['threadid'])->pluck('id'); if (empty($post_detail)) { return false; } if (!empty($tid)) { echo "<br>"; $row = $Eveapi->find($tid); if ($row->lastpost_time == date('Y-m-d H:i:s', strtotime($date))) { echo "Already Updated"; $row->topicreplies = $post_detail['topicreplies']; $row->topiclikes = $post_detail['topiclikes']; $row->topicviews = $post_detail['topicviews']; $save = $row->save(); return $save; } echo "<br>"; echo $tid . " updated with " . $date; $row->lastpost_time = date('Y-m-d H:i:s', strtotime($date)); $row->update_status = 0; $save = $row->save(); return $save; } $Eveapi->maintitle = $post_detail['maintitle']; $Eveapi->threadid = $post_detail['threadid']; $Eveapi->pilotname = $post_detail['pilotname']; $Eveapi->topicreplies = $post_detail['topicreplies']; $Eveapi->topiclikes = $post_detail['topiclikes']; $Eveapi->topicviews = $post_detail['topicviews']; $Eveapi->lastpost_time = date('Y-m-d H:i:s', strtotime($date)); echo "<br>"; echo "Inserted"; $save_Eveapi = $Eveapi->save(); return $save_Eveapi; }