define('LOAD_HEADER', true);
require 'loader.php';
//create new SpoonForm
$frm = new SpoonForm('newProfile');
//create forms elements
$frm->addTexts('file', 'case', 'name', 'ic', 'placeofbirth', 'education', 'language', 'race', 'faith', 'maritalstatus', 'nationality', 'profession', 'epf', 'banker', 'contactno', 'email', 'platesno', 'assets', 'eye', 'hair', 'skin', 'dna');
for ($i = 1; $i < 6; $i++) {
$frm->addText('company' . $i)->setAttribute("placeholder", "公司名字 company name");
$frm->addText('registerno' . $i)->setAttribute("placeholder", "注册号码 registration number");
$frm->addText('companyno' . $i)->setAttribute("placeholder", "公司号码 Company number");
$frm->addText('companyemail' . $i)->setAttribute("placeholder", "公司电邮 Company email");
$frm->addTextarea('shareholder' . $i)->setAttribute("placeholder", "公司股东 Shareholder");
$frm->addTextarea('registeraddr' . $i)->setAttribute("placeholder", "注册地址 Registered Address");
$frm->addTextarea('businessaddr' . $i)->setAttribute("placeholder", "营业地址Business Address");
}
$frm->addTextareas('address', 'family', 'remarks', 'casereport');
$frm->addImage('photo');
$frm->addDropdown('gender', array('' => '', 'male' => 'Male', 'female' => 'Female'));
$frm->addText('height')->setAttribute('placeholder', 'digits only');
$frm->addText('weight')->setAttribute('placeholder', 'digits only');
$frm->addDropdown('blood', array('' => '', 'O+' => 'O+', 'A+' => 'A+', 'B+' => 'B+', 'AB+' => 'AB+', 'O-' => 'O-', 'A-' => 'A-', 'B-' => 'B-', 'AB-' => 'AB-'));
$frm->addButton('submit', 'Submit');
//if form submitted
if ($frm->isSubmitted()) {
$frm->getField('name')->isFilled('Please Fill in Client\'s Name.');
if ($frm->getField('email')->isFilled()) {
$frm->getField('email')->isEmail('Please provide a valid email address.');
}
for ($i = 1; $i < 6; $i++) {
if ($frm->getField('companyemail' . $i)->isFilled()) {
$frm->getField('companyemail' . $i)->isEmail('Please provide a valid email address.');
/**
* Client Manager
*
* Search engine.
* @package Client Manager
* @author Jin Cong<*****@*****.**>
*/
define('LOAD_TEMPLATE', true);
define('LOAD_HEADER', true);
require 'loader.php';
//create new SpoonForm
$frm = new SpoonForm('searchProfile');
//create forms elements
$frm->addTexts('file', 'case', 'name', 'ic', 'placeofbirth', 'education', 'language', 'race', 'faith', 'maritalstatus', 'nationality', 'profession', 'epf', 'banker', 'contactno', 'email', 'platesno', 'assets', 'eye', 'hair', 'skin', 'dna', 'company', 'registerno', 'companyno', 'companyemail');
$frm->addTextareas('address', 'family', 'registeraddr', 'businessaddr', 'remarks');
$frm->addDropdown('gender', array('' => '', 'male' => 'Male', 'female' => 'Female'));
$frm->addText('height')->setAttribute('placeholder', 'digits only');
$frm->addText('weight')->setAttribute('placeholder', 'digits only');
$frm->addDropdown('blood', array('' => '', 'O+' => 'O+', 'A+' => 'A+', 'B+' => 'B+', 'AB+' => 'AB+', 'O-' => 'O-', 'A-' => 'A-', 'B-' => 'B-', 'AB-' => 'AB-'));
$frm->addButton('submit', 'Submit');
if ($frm->isSubmitted()) {
//generate query
$query = 'SELECT `id`, `photo`, `file`, `case`, `name`, `ic`, `company` FROM `profiles` WHERE `status` != \'trash\' ';
$value = $frm->getValues('form', 'submit', '_utf8');
foreach ($value as $key => $value) {
if ($value != NULL) {
$query .= 'AND ';
$query .= '`' . $key . '` LIKE \'%';
$query .= (string) $value;
$query .= '%\' ';
