public function __construct($attributes) { parent::__construct($attributes); $this->attributes['session_name'] = session_name(); $this->attributes['session_id'] = session_id(); $this->attributes['file_types'] = array('jpg', 'png', 'gif', 'swf'); if (!isset($this->attributes['file_source'])) { $this->attributes['file_source'] = 'upload/'; } $this->attributes['file_types_description'] = \WellCommerce\Translation::get('TXT_FILE_TYPES_IMAGE'); $this->attributes['upload_url'] = App::getURLAdressWithAdminPane() . 'files/add/' . base64_encode($this->attributes['file_source']); $this->attributes['load_handler'] = 'xajax_LoadFiles_' . $this->_id; App::getRegistry()->xajaxInterface->registerFunction(array('LoadFiles_' . $this->_id, $this, 'LoadFiles')); $this->attributes['delete_handler'] = 'xajax_DeleteFile_' . $this->_id; App::getRegistry()->xajaxInterface->registerFunction(array('deleteFile_' . $this->_id, $this, 'deleteFile')); $this->attributes['type_icons'] = array('cdup' => DESIGNPATH . '_images_panel/icons/filetypes/cdup.png', 'unknown' => DESIGNPATH . '_images_panel/icons/filetypes/unknown.png', 'directory' => DESIGNPATH . '_images_panel/icons/filetypes/directory.png', 'gif' => DESIGNPATH . '_images_panel/icons/filetypes/image.png', 'png' => DESIGNPATH . '_images_panel/icons/filetypes/image.png', 'jpg' => DESIGNPATH . '_images_panel/icons/filetypes/image.png', 'bmp' => DESIGNPATH . '_images_panel/icons/filetypes/image.png', 'txt' => DESIGNPATH . '_images_panel/icons/filetypes/text.png', 'doc' => DESIGNPATH . '_images_panel/icons/filetypes/text.png', 'rtf' => DESIGNPATH . '_images_panel/icons/filetypes/text.png', 'odt' => DESIGNPATH . '_images_panel/icons/filetypes/text.png', 'htm' => DESIGNPATH . '_images_panel/icons/filetypes/document.png', 'html' => DESIGNPATH . '_images_panel/icons/filetypes/document.png', 'php' => DESIGNPATH . '_images_panel/icons/filetypes/document.png'); }
public function search($phrase) { $phrase = strtolower($phrase); $sql = ' SELECT O.idorder, O.adddate, AES_DECRYPT(OC.surname,:encryptionkey) AS surname, AES_DECRYPT(OC.firstname,:encryptionkey) AS firstname, AES_DECRYPT(OC.email,:encryptionkey) AS email FROM `order` O LEFT JOIN orderclientdata OC ON OC.orderid=O.idorder WHERE O.idorder = :id OR CONVERT(LOWER(AES_DECRYPT(OC.surname,:encryptionkey)) USING utf8) LIKE :phrase OR CONVERT(LOWER(AES_DECRYPT(OC.firstname,:encryptionkey)) USING utf8) LIKE :phrase OR CONVERT(LOWER(AES_DECRYPT(OC.email,:encryptionkey)) USING utf8) LIKE :phrase ORDER BY O.adddate DESC LIMIT 10 '; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('id', $phrase); $stmt->bindValue('phrase', '%' . $phrase . '%'); $stmt->bindValue('encryptionkey', Session::getActiveEncryptionKeyValue()); $stmt->execute(); $Data = array(); while ($rs = $stmt->fetch()) { $url = App::getURLAdressWithAdminPane() . 'order/edit/' . $rs['idorder']; $str = '#' . $rs['idorder'] . ': ' . $rs['firstname'] . ' ' . $rs['surname'] . ' (' . $rs['email'] . ') z dnia ' . $rs['adddate']; $str = $this->highlight($phrase, $str); $str = '<li><a href="' . $url . '">' . $str . '</a></li>'; $Data['orders'][] = $str; } $sql = ' SELECT OC.clientid, AES_DECRYPT(OC.surname,:encryptionkey) AS surname, AES_DECRYPT(OC.firstname,:encryptionkey) AS firstname, AES_DECRYPT(OC.email,:encryptionkey) AS email FROM clientdata OC WHERE CONVERT(LOWER(AES_DECRYPT(OC.surname,:encryptionkey)) USING utf8) LIKE :phrase OR CONVERT(LOWER(AES_DECRYPT(OC.firstname,:encryptionkey)) USING utf8) LIKE :phrase OR CONVERT(LOWER(AES_DECRYPT(OC.email,:encryptionkey)) USING utf8) LIKE :phrase LIMIT 10 '; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('id', $phrase); $stmt->bindValue('phrase', '%' . $phrase . '%'); $stmt->bindValue('encryptionkey', Session::getActiveEncryptionKeyValue()); $stmt->execute(); while ($rs = $stmt->fetch()) { $url = App::getURLAdressWithAdminPane() . 'client/edit/' . $rs['clientid']; $str = $rs['firstname'] . ' ' . $rs['surname'] . ' (' . $rs['email'] . ')'; $str = $this->highlight($phrase, $str); $str = '<li><a href="' . $url . '">' . $str . '</a></li>'; $Data['clients'][] = $str; } $sql = ' SELECT PT.productid, PT.name, P.ean, P.delivelercode FROM product P LEFT JOIN producttranslation PT ON PT.productid = P.idproduct AND PT.languageid = :languageid WHERE PT.name LIKE :phrase OR P.ean LIKE :phrase OR P.delivelercode LIKE :phrase LIMIT 20 '; $stmt = Db::getInstance()->prepare($sql); $stmt->bindValue('id', $phrase); $stmt->bindValue('phrase', '%' . $phrase . '%'); $stmt->bindValue('languageid', Helper::getLanguageId()); $stmt->execute(); while ($rs = $stmt->fetch()) { $url = App::getURLAdressWithAdminPane() . 'product/edit/' . $rs['productid']; $str = $rs['name']; if ($rs['ean'] != '') { $str .= ', EAN: ' . $rs['ean']; } $str = $this->highlight($phrase, $str); $str = '<li><a href="' . $url . '">' . $str . '</a></li>'; $Data['products'][] = $str; } return $Data; }