public function registerClient($data)
{
if (empty($data) || !is_array($data)) {
return NULL;
}
$db = PR_Database::getInstance();
$ClientID = false;
$mapping = array("firstname" => "firstname", "lastname" => "lastname", "emailaddress" => "emailaddress", "usertype" => "usertype", "password" => "password", "HeardFrom" => "HeardFrom", "CompanyID" => "CompanyID");
foreach ($data as $id => $value) {
if (!array_key_exists($id, $mapping) || empty($value)) {
continue;
}
$data[$mapping[$id]] = $value;
}
$api = new PR_Api_Core_ClientClass();
$defaultCompany = $api->getDefaultCompany();
$defaultCompanyID = $defaultCompany['CompanyID'];
// echo ("defaultCompanyID:".$defaultCompanyID);
$primaryEmail = $data["emailaddress"];
$maxIdSql = "SELECT MAX(UserID) AS UserID FROM user";
$result = $db->fetchAll($maxIdSql);
$User_ID = $result[0]['UserID'] + 1;
$select = $db->select()->from(PR_Database::TABLE_USER, array('emailaddress'));
$select->where("emailaddress = '{$primaryEmail}'");
$res = $db->fetchAll($select);
if (!empty($res) && count($res) > 0) {
return array("error" => "email exists");
echo "email exists";
} else {
if ($data['usertype'] == 1) {
// echo ("tetstt:<pre>");print_r($data);echo("</pre>");die();
$maxIdSql = "SELECT MAX(CompanyID) AS CompanyID FROM company";
$result = $db->fetchAll($maxIdSql);
$CompanyID = $result[0]['CompanyID'];
/* $Companyname=$data['Companyname'];
$select1 = $db->select()->from(PR_Database::TABLE_COMPANY,
array('Companyname'));
$select1->where("Companyname = '$Companyname'");
$res1 = $db->fetchAll($select1);
if(!empty($res1) && count($res1) > 0 ) {
return array("error" => "Company name exists","CompanyID"=>"");
echo("Companyname exists");
}else{
$updateFields=array(
'CompanyID'=>$CompanyID,
'Companyname'=>$data['Companyname']
);
$result = PR_Database::insert("company", $updateFields);
// return $CompanyID;
return array("error"=>"","CompanyID" => "$CompanyID");
} */
//
$db->insert(PR_Database::TABLE_USER, array("UserID" => $User_ID, "firstname" => $data['firstname'], "lastname" => $data['lastname'], "usertype" => $data['usertype'], "emailaddress" => $data['emailaddress'], "password" => $data['password'], "HeardFrom" => $data['HeardFrom'], "CompanyID" => $CompanyID));
}
if ($data['usertype'] == 2) {
$db->insert(PR_Database::TABLE_USER, array("UserID" => $User_ID, "firstname" => $data['firstname'], "lastname" => $data['lastname'], "usertype" => $data['usertype'], "emailaddress" => $data['emailaddress'], "password" => $data['password'], "HeardFrom" => $data['HeardFrom']));
}
}
$db->commit();
}
