/** * Clubs status check * @name getClubstatus * @access public * @return array of setting for each * club */ public function getClubstatusNFC() { $clbs = array(); $date = date('Y-m-d'); $sql = "select* from club_monitoring where continent=2"; $rs = $this->query($sql); if ($rs->hasResults()) { foreach ($rs->fetchAll() as $row) { $clb = new Application_Model_NevClub(); $clb->setClubid($row['clubid']); $bodsend = $date . " " . $row['bodsend']; $clb->setBodsend($bodsend); $clb->setBodmsg($row['bodmsg']); $clb->setBodconf($row['bodconf']); $blng1_send = $date . " " . $row['blngfirstsend']; $clb->setBlngfirstsend($blng1_send); $clb->setBlngfirstmsg($row['blngfirstmsg']); $clb->setBlngfirstconf($row['blngfirstconf']); $blng2_send = $date . " " . $row['blngsecondsend']; $clb->setBlngsecondsend($blng2_send); $clb->setBlngsecondmsg($row['blngsecondmsg']); $clb->setBlngsecondconf($row['blngsecondconf']); $blng3_send = $date . " " . $row['blngthirdsend']; $clb->setBlngthirdsend($blng3_send); $clb->setBlngthirdmsg($row['blngthirdmsg']); $clb->setBlngthirdconf($row['blngthirdconf']); $blng4_send = $date . " " . $row['blngfourthsend']; $clb->setBlngfourthsend($blng4_send); $clb->setBlngfourthmsg($row['blngfourthmsg']); $clb->setBlngfourthconf($row['blngfourthconf']); $campsend = $date . " " . $row['campaignsend']; $clb->setCampaignsend($campsend); $clb->setCampaignmsg($row['campaignmsg']); $clb->setCampaignconf($row['campaignconf']); $clb->setTimezone($row['timezone']); $clb->setNevid($row['nevid']); $clbs[] = $clb; } } return $clbs; }