PHP ZippyERP\ERP\Entity Item::qstr Examples

Example #1

File: itemlist.php Project: Niqpue/zippyerp

 private function getWhere()
 {
     $where = "1=1 ";
     $form = $this->page->filter;
     if ($form->group->getValue() > 0) {
         $where = $where . " and group_id=" . $form->group->getValue();
     }
     if (strlen($form->searchkey->getText()) > 0) {
         $where = $where . " and (itemname like " . Item::qstr('%' . $form->searchkey->getText() . '%') . " or description like " . Item::qstr('%' . $form->searchkey->getText() . '%') . " )  ";
     }
     return $where;
 }