php - Error: Call to a member function setPayrollperiodid() on null -


i'm trying count number of payroll week matches payroll period entered. returns correct number won't add database instead says there's no match in database. when make changes error:

error: call member function setpayrollperiodid() on null.

i have outlined have far. can tell me went wrong.

i have made updates question no longer error record isn't adding instead it's saying doesn't match did go wrong in controller.

repository

class payrollweekrepository extends entityrepository {     public function findbystartdateandenddate($startdate, $enddate)     {         $repository = $this->getentitymanager()             ->getrepository('comtwclagripayrollbundle:payrollweek');          $qb = $repository->createquerybuilder('pw');         $qb->select('pw');         $qb->where('pw.startdate=:startdate');         $qb->andwhere('pw.enddate=:enddate');         $qb->setparameter('startdate', $startdate);         $qb->setparameter('enddate', $enddate);         $qb->getquery()->getresult();     }      public function countbystartdateandenddate($startdate, $enddate)     {         $repository = $this->getentitymanager()             ->getrepository('comtwclagripayrollbundle:payrollweek');          $qb = $repository->createquerybuilder('pw');         $qb->select('count(pw.id)');         $qb->where('pw.startdate=:startdate or pw.enddate=:enddate');         $qb->setparameter('startdate', $startdate);         $qb->setparameter('enddate', $enddate);          $count = $qb->getquery()->getsinglescalarresult();          var_dump($count);         return $count;     } }

controller

public function createaction(request $request) {     $entity = new payrollperiod();      $form = $this->createcreateform($entity);     $form->handlerequest($request);      if ($form->issubmitted() && $form->isvalid()) {            $em = $this->getdoctrine()->getmanager();          $payrollperiod = $em->getrepository('comtwclagripayrollbundle:payrollperiod')             ->findoneby([                 'startdate' => $form->get('startdate')->getdata(),                 'enddate' => $form->get('enddate')->getdata()]             );          $payrollweek = $em->getrepository('comtwclagripayrollbundle:payrollweek')             ->findbystartdateandenddate($entity->getstartdate() , $entity->getenddate());          $counter = $em->getrepository('comtwclagripayrollbundle:payrollweek')             ->countbystartdateandenddate($entity->getstartdate() , $entity->getenddate());          //if entity exists         if ($payrollperiod){             $this->addflash('error', 'error: payroll period present same start , end date.');             return $this->redirect($this->generateurl('payrollperiod'));         }         //if payrollweek matches payrollperiod entered         elseif ( $counter==2){            $payrollweek->setpayrollperiodid($entity);          }          $em->persist($entity);         $em->flush();          $this->addflash('success', 'payroll period added.');         $this->addflash('success', 'payroll week updated.');         return $this->redirect($this->generateurl('payrollperiod'));         //return $this->redirect($this->generateurl('payrollperiod_show', array('payrollperiodid' => $entity->getpayrollperiodid())));     }     else{         $this->addflash('error', 'payroll period not match payroll week.');         return $this->redirect($this->generateurl('payrollperiod'));       }      //return $this->render('comtwclagripayrollbundle::new.html.twig',array('form' => $form->createview()));     return array(         'entity' => $entity,         'form'   => $form->createview(),     );    }

updates

public function countbystartdateandenddate($startdate, $enddate) {     $repository = $this->getentitymanager()         ->getrepository('comtwclagripayrollbundle:payrollweek');      $qb = $repository->createquerybuilder('pw');     $qb->select('count(pw.id)');     $qb->where('pw.startdate=:startdate or pw.enddate=:enddate');     $qb->setparameter('startdate', $startdate);     $qb->setparameter('enddate', $enddate);      $count = $qb->getquery()->getresult();      var_dump($count);     return $count; }  public function createaction(request $request) {       $entity = new payrollperiod();      $form = $this->createcreateform($entity);      $form->handlerequest($request);           if ($form->issubmitted() && $form->isvalid()) {           $em = $this->getdoctrine()->getmanager();          $payrollperiod = $em->getrepository('comtwclagripayrollbundle:payrollperiod')->findoneby(['startdate'=>$form->get('startdate')->getdata(), 'enddate'=>$form->get('enddate')->getdata()]);          //$payrollweek = $em->getrepository('comtwclagripayrollbundle:payrollweek')->findbystartdateandenddate($form->get('startdate')->getdata(), $form->get('enddate')->getdata());          $counter = $em->getrepository('comtwclagripayrollbundle:payrollweek')->countbystartdateandenddate($form->get('startdate')->getdata(), $form->get('enddate')->getdata());           //if entity exists         if ($payrollperiod){                 $this->addflash('error', 'error: payroll period present same start , end date.');                 return $this->redirect($this->generateurl('payrollperiod'));             }             //if payrollweek matches payrollperiod entered            elseif ($counter==2){             foreach ($counter $pweek) {                  $pweek->setpayrollperiodid($entity);               }            $em->persist($entity);           $em->flush();              $this->addflash('success', 'payroll period added.');             $this->addflash('success', 'payroll week updated.');             return $this->redirect($this->generateurl('payrollperiod'));            //return $this->redirect($this->generateurl('payrollperiod_show', array('payrollperiodid' => $entity->getpayrollperiodid())));              }              else{                $this->addflash('error', 'payroll period not match payroll week.');             return $this->redirect($this->generateurl('payrollperiod'));                }        }         //return $this->render('comtwclagripayrollbundle::new.html.twig',array('form' => $form->createview()));        return array(            'entity' => $entity,            'form'   => $form->createview(),        );             }

further updates

public function createaction(request $request) {       $entity = new payrollperiod();      $form = $this->createcreateform($entity);      $form->handlerequest($request);           if ($form->issubmitted() && $form->isvalid()) {           $em = $this->getdoctrine()->getmanager();          $payrollperiod = $em->getrepository('comtwclagripayrollbundle:payrollperiod')->findoneby(['startdate'=>$form->get('startdate')->getdata(), 'enddate'=>$form->get('enddate')->getdata()]);          $payrollweek = $em->getrepository('comtwclagripayrollbundle:payrollweek')->findbystartdateandenddate($form->get('startdate')->getdata(), $form->get('enddate')->getdata());            //if entity exists             if ($payrollperiod){                     $this->addflash('error', 'error: payroll period present same start , end date.');                     return $this->redirect($this->generateurl('payrollperiod'));                 }             //if payrollweek matches payrollperiod entered             elseif ($payrollweek){               $count = count($payrollweek);             foreach ($payrollweek $pweek) {             $pweek->setpayrollperiodid($entity);              }               $em->persist($entity);             $em->flush();              $this->addflash('success', 'payroll period added.');             $this->addflash('success', 'payroll week updated.');             return $this->redirect($this->generateurl('payrollperiod'));            //return $this->redirect($this->generateurl('payrollperiod_show', array('payrollperiodid' => $entity->getpayrollperiodid())));              }              else{                $this->addflash('error', 'payroll period not match payroll week.');             return $this->redirect($this->generateurl('payrollperiod'));                } }           //return $this->render('comtwclagripayrollbundle::new.html.twig',array('form' => $form->createview()));        return array(            'entity' => $entity,            'form'   => $form->createview(),        );             }

you're not checking $payrollweek exists before trying use it. in case, didn't find value when ran function:

$payrollweeks = $em->getrepository('comtwclagripayrollbundle:payrollweek')     ->findbystartdateandenddate($entity->getstartdate() , $entity->getenddate());

since didn't find anything, $payrollweek null instead of instance of payrollweek entity. add check this:

if (!$payrollweeks) {     $this->addflash(         'error',         'error: no payroll week found given start , end date'     );      return $this->redirect($this->generateurl('payrollperiod')); }

edit based on discussions:

you should able rid of countbystartdateandenddate() function , use php's count() function results want, loop on payroll weeks:

$count = count($payrollweeks);  foreach ($payrollweeks $payrollweek) {     $payrollweek->setpayrollperiodid($entity);  }

Comments

Post a Comment

Popular posts from this blog

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m
Read more

javascript - Z-index in d3.js -

i have map , when hover effect on region of map below yellow line , circle, last ones disappear. how can solve problem? http://jsfiddle.net/ot21n9qx/ var arc = g.append("path") .style("fill", "none") .style("stroke", "yellow") .style("stroke-width", 2) .attr("d", "m" + pathorigin[0] + "," + pathorigin[1] + " q" + svgpoint[0] + "," + pathorigin[1] + " " + svgpoint[0] + "," + svgpoint[1]); var circlesize = d3.scale.linear() .domain([0, 0.5, 1]) .range([4, 10, 4]); svg not have z order draws objects in order created. need create path , circle after create highlight regions. here forked fiddle: http://jsfiddle.net/o00fzgaf/1/
Read more