$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;
}
