public static function syncFranchiseUser($user)
{
$fuser = User::model()->findByPk($user->id);
if (!$fuser) {
$fuser = new User();
}
$fuser->id = $user->id;
$fuser->username = $user->username;
$fuser->name = $user->username;
$fuser->password = gethash('secret');
$fuser->address = $user->address;
$fuser->email = $user->email;
$fuser->phone = $user->mobile;
$fuser->franchise = $user->id;
$fuser->role_id = 3;
$fuser->save();
}
function register_save()
{
$password = $_REQUEST['password'];
$name = $_REQUEST['name'];
$username = $_REQUEST['username'];
$email = $_REQUEST['email'];
$gender = $_REQUEST['gender'];
$age = $_REQUEST['age'];
$query = $_DB->Query("select * from jos_users where username='******'");
//and from_mobile_id='$from_mobile_id'");
$count = $_DB->GetResultNumber($query);
// $res = mysql_query($query);
if ($count > 0) {
$dataDB['Result']['Data'][0] = array('Status' => "Username Already Exist");
echo json_encode($dataDB);
} else {
$salt = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
$len = strlen($salt);
$makepass = '';
$length = 32;
$stat = @stat(__FILE__);
if (empty($stat) || !is_array($stat)) {
$stat = array(php_uname());
}
mt_srand(crc32(microtime() . implode('|', $stat)));
for ($i = 0; $i < $length; $i++) {
$makepass .= $salt[mt_rand(0, $len - 1)];
}
$salt = $makepass;
$crypt = getCryptedPassword($password, $salt);
$array['password'] = $crypt . ':' . $salt;
$password = $array['password'];
$act = gethash(genAct());
$reg_date = date('Y-m-d H:i:s');
$sql = $_DB->Execute("INSERT INTO jos_users(name,username,email,password,usertype,block,sendEmail,gid,registerDate,activation) VALUES ('{$name}','{$username}','{$email}','{$password}','Registered','0','0','18','{$reg_date}','{$act}')");
//mysql_query($sql);
//echo $sql."jhkjhjk";
$sql = $_DB->Query("SELECT * FROM jos_users WHERE username = '******'");
//$uid = mysql_query($sql);
$user_id = $_DB->GetResultValue($sql, 0, 'id');
$gid = $_DB->GetResultValue($sql, 0, 'gid');
/*while ($row = mysql_fetch_assoc($uid)) {
$user_id = $row['id'];
$gid = $row['gid'];
}*/
$query = $_DB->Query("INSERT INTO jos_core_acl_aro(section_value,value,order_value,name,hidden) VALUES ('users','{$user_id}','0','{$name}','0')");
//mysql_query($query);
$sql = $_DB->Query("SELECT * FROM jos_core_acl_aro WHERE value = {$user_id}");
//$aro = mysql_query($sql);
$aid = $_DB->GetResultValue($sql, 0, 'id');
/*while ($row = mysql_fetch_assoc($aro)) {
$aid = $row['id'];
}*/
$query = $_DB->Execute("INSERT INTO jos_core_acl_groups_aro_map(group_id,section_value,aro_id) VALUES ('{$gid}','','{$aid}')");
//mysql_query($query);
$query = $_DB->Execute("INSERT INTO user_profile(gender,age,user_id) VALUES ('{$gender}','{$age}','{$user_id}')");
//mysql_query($query);
$count = $_DB->GetResultNumber($query);
//if(mysql_affected_rows()>0)
if ($count > 0) {
$dataDB['Result']['Data'][0] = array('Status' => "Registered Successfully");
echo json_encode($dataDB);
} else {
$dataDB['Result']['Data'][0] = array('Status' => "Registration Failed");
echo json_encode($dataDB);
}
}
}
function forward($name, $mail_to, $room_no, $request_id, $original_mail_id, $cc)
{
$hash = gethash($request_id);
$date = date('Y-m-d H:i:s');
$body = "Sir,\n" . $name . " with mail id " . $original_mail_id . " has sent the Request for Room no. " . $room_no . ".The Request id is. " . $request_id . " . Kindly check and if possible give your consent\n\n.";
$message = " \n\t\t<html>\n\t\t<body>\n\t\t<p>" . $body . "</p>\n\t\t<p> Click <a href=\"http://localhost/roomReservationSystem/SSAD/req_detail_hash.php?hash=" . $hash . "\"> here </a>to verify the request! </p>\n\t\t\n\n\n\nCheers,\nAdmins\n\n\n\nMail generated at: " . $date . "\n\t\t</body>\n\t\t</html>";
$subject = "Room allocation: Request forwarded";
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'From: Noreply <*****@*****.**>' . "\r\n";
$headers .= "Cc: {$cc}" . "\r\n";
mail($mail_to, $subject, $message, $headers);
}
