/**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function getIndex()
 {
     $varr = Auth::user()->empid;
     $empid = Targetassign::where('Employeeid', $varr)->get();
     $cat = Event::all();
     return View('targetmodule/eventdeal')->with(array('cat' => $cat, 'empid' => $empid));
 }
 public function postUpdatetargetassign(Request $request)
 {
     $tid = Input::get('targetid');
     $now = date('d-m-Y');
     $post = Input::get();
     $i = Targetassign::where('Id', $tid)->update(array('Targetvalue' => $post['targetvalue'], 'Targetdate' => $post['duedate']));
     if ($i > 0) {
         $request->session()->flash('alert-success', 'Target Has Been Updated Successfully');
         return redirect('targetmodule/assigntarget');
     }
 }
 public function postVariancecard()
 {
     $empid = Auth::user()->empid;
     $eventName = Input::get('event');
     $targets = Targetassign::where('Employeeid', $empid)->where('Eventname', $eventName)->get();
     $variancedata = $targets;
     $deals = Deal::where('Eventname', $eventName)->where('Empid', $empid)->get();
     $eventDate = Event::where('event', $eventName)->select('date')->get();
     $userData = array();
     $key = 0;
     foreach ($eventDate as $val) {
         $eventdate = $val['date'];
     }
     foreach ($targets as $target) {
         $achieved = 0;
         $userData[$key]['event'] = $target->Eventname;
         $userData[$key]['eventcode'] = $target->Eventcode;
         $userData[$key]['targetVal'] = $target->Targetvalue;
         foreach ($deals as $key1 => $deal) {
             if ($target->Eventname == $deal->Eventname) {
                 $achieved = $achieved + $deal->Dealvalue;
                 $dealx[$key1]['dealdate'] = $deal->Dealdate;
                 $dealx[$key1]['cost'] = (double) $deal->Dealvalue;
             }
         }
         $userData[$key]['achieved'] = $achieved;
         $userData[$key]['variance'] = $achieved - $target->Targetvalue;
         $userData[$key]['cur'] = $target->Currency;
         $date2 = strtotime(date('d-m-Y'));
         $date1 = $target->Targetdate;
         $date5 = $target->Targetassigned;
         // dd($date5);
         $date3 = strtotime($target->Targetdate);
         $diff = $date3 - $date2;
         $days = floor($diff / (60 * 60 * 24));
         // dd($days);
         $userData[$key]['dayleft'] = $days;
         $key++;
     }
     $dealjson = json_encode($dealx);
     // dd($dealjson);
     return View('targetmodule/variancecard')->with(array('target' => $targets, 'userdata' => $userData, 'variancedata' => $variancedata, 'eventdate' => $date1, 'targetdate' => $date5, 'dealjson' => $dealjson));
 }
 public function getUpdatenewdeal($editleadid)
 {
     $varr = Auth::user()->empid;
     $evarr = User::where('empid', $varr)->get();
     $emp = Employee::where('emp_ide_id', $varr)->get();
     $date = date('Y-m-d');
     $ev = array();
     $cat = Event::where('date', '>=', $date)->get();
     // dd($cat);
     foreach ($cat as $key) {
         $ev[] = $key['eventcode'];
     }
     // dd($ev);
     $leadid = leadsheet::where('id', $editleadid)->get();
     // dd($leadid);
     $dealcan = Deal::where('Status', '=', 'Request Cancel')->where('Empid', $varr)->get();
     $event = Event::all();
     $empid = Targetassign::where('Employeeid', $varr)->whereIn('Eventcode', $ev)->get();
     return View('initiator/updatenewdeal')->with(array('evarr' => $evarr, 'emp' => $emp, 'empid' => $empid, 'leadid' => $leadid, 'cat' => $cat));
 }