$arrConfig['AMPDBHOST']['valor'] . "/asterisk"; $oDB = new paloDB($dsn); */ $module_name = 'customer'; $arrConf['cadena_dsn'] = "mysql://*****:*****@localhost/call_center"; require_once dirname(__FILE__) . "/libs/JSON.php"; include_once "/var/www/html/modules/{$module_name}/libs/paloSantoAdressBook.class.php"; include_once "/var/www/html/libs/paloSantoDB.class.php"; $json = new Services_JSON(); header("Content-type: application/json"); /* get booker list */ if (isset($_REQUEST['booker_list'])) { $pDB = new paloDB($arrConf['cadena_dsn']); // address_book $padress_book = new paloAdressBook($pDB); $arrBooker = $padress_book->getBookerList(); echo $json->encode($arrBooker); return; } /* end of get booker list */ $page = isset($_POST['page']) ? $_POST['page'] : 1; $rp = isset($_POST['rp']) ? $_POST['rp'] : 10; $sortname = isset($_POST['sortname']) ? $_POST['sortname'] : 'firstname'; $sortorder = isset($_POST['sortorder']) ? $_POST['sortorder'] : 'asc'; $query = isset($_POST['query']) && trim($_POST['query']) != '' ? '%' . $_POST['query'] . '%' : null; $qtype = isset($_POST['qtype']) ? $_POST['qtype'] : null; if (is_null($query)) { $qtype = null; } $letter = isset($_POST['letter_pressed']) && trim($_POST['letter_pressed']) != '' ? $_POST['letter_pressed'] : null; $sort = "{$sortname} {$sortorder}";
function createFieldForm($pDB) { $pBooker = new paloAdressBook($pDB); $arrBooker = $pBooker->getBookerList(); $arrPayment_type = $pBooker->getPaymentTypeList(); $arrFields = array("firstname" => array("LABEL" => "Tên khách hàng", "REQUIRED" => "yes", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;", "id" => "firstname"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "lastname" => array("LABEL" => "Họ và tên lót", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "birthday" => array("LABEL" => "Ngày sinh", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;", "id" => "birthday"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "birthplace" => array("LABEL" => "Nơi sinh", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "cmnd" => array("LABEL" => "Số CMND", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "^[\\*|#]*[[:digit:]]*\$"), "passport" => array("LABEL" => "Số Passport", "REQUIRED" => "no", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "INPUT_TYPE" => "TEXT", "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "^[\\*|#]*[[:digit:]]*\$"), "phone" => array("LABEL" => "Số điện thoại", "REQUIRED" => "yes", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "^[\\*|#]*[[:digit:]]*\$"), "address" => array("LABEL" => "Địa chỉ", "REQUIRED" => "no", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "email" => array("LABEL" => "Email", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company" => array("LABEL" => "Công ty", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "booker" => array("LABEL" => "NV Booker", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBooker, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "sale" => array("LABEL" => "NV Sale", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "sale" => array("LABEL" => "NV Sale", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "accountant" => array("LABEL" => "NV Kế toán", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "membership" => array("LABEL" => "Thẻ thành viên", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "payment_type" => array("LABEL" => "Thanh toán", "EDITABLE" => "yes", "REQUIRED" => "no", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrPayment_type, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "customer_code" => array("LABEL" => "Mã khách hàng", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_name" => array("LABEL" => "Tên khách hàng", "REQUIRED" => "yes", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;", "id" => "company_name"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_address" => array("LABEL" => "Địa chỉ", "REQUIRED" => "no", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_code" => array("LABEL" => "Mã khách hàng", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_booker" => array("LABEL" => "NV Booker", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBooker, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_sale" => array("LABEL" => "NV Sale", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_accountant" => array("LABEL" => "NV Kế toán", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_membership" => array("LABEL" => "Thẻ thành viên", "REQUIRED" => "yes", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "company_pay_type" => array("LABEL" => "Thanh toán", "EDITABLE" => "yes", "REQUIRED" => "no", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrPayment_type, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "")); return $arrFields; }
function createFieldForm($pDB) { $pBooker = new paloAdressBook($pDB); $arrBooker = $pBooker->getBookerList(); $arrAccountant = $pBooker->getAccountantList(); $arrSale = $pBooker->getSaleList(); $arrProvince = $pBooker->getProvinceList(); $arrDistrict = $pBooker->getDistrictList(); $arrFields = array("customer_name" => array("LABEL" => "Tên khách hàng", "REQUIRED" => "yes", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;", "id" => "firstname"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "birthday" => array("LABEL" => "Ngày sinh", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;", "id" => "birthday"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "birthplace" => array("LABEL" => "Nơi sinh", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "cmnd" => array("LABEL" => "Số CMND", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "^[\\*|#]*[[:digit:]]*\$"), "passport" => array("LABEL" => "Số Passport", "REQUIRED" => "no", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "INPUT_TYPE" => "TEXT", "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "^[\\*|#]*[[:digit:]]*\$"), "phone" => array("LABEL" => "Số điện thoại", "REQUIRED" => "yes", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "^[\\*|#]*[[:digit:]]*\$"), "address" => array("LABEL" => "Địa chỉ", "REQUIRED" => "no", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "email" => array("LABEL" => "Email", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "booker_view" => array("LABEL" => "NV Booker", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrBooker, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "sale_view" => array("LABEL" => "NV Sale", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrSale, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "accountant_view" => array("LABEL" => "NV Kế toán", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrAccountant, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "province_view" => array("LABEL" => "Tỉnh/thành", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrProvince, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "district_view" => array("LABEL" => "Quận/huyện", "EDITABLE" => "yes", "REQUIRED" => "yes", "INPUT_TYPE" => "SELECT", "INPUT_EXTRA_PARAM" => $arrDistrict, "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "membership" => array("LABEL" => "Thẻ thành viên", "REQUIRED" => "no", "INPUT_TYPE" => "TEXTAREA", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => ""), "customer_code" => array("LABEL" => "Mã khách hàng", "REQUIRED" => "no", "INPUT_TYPE" => "TEXT", "INPUT_EXTRA_PARAM" => array("style" => "width:200px;"), "VALIDATION_TYPE" => "text", "VALIDATION_EXTRA_PARAM" => "")); return $arrFields; }