function update_userinfo($userid, $info)
{
$returnarray = array('status' => 500, 'content' => 'Update info fail!');
$userdata = json_decode($info);
$full_name = clean_text($userdata->{'fullname'});
$id_pwc = (int) clean_text($userdata->{'pcid'});
$pcname = clean_text($userdata->{'pcname'});
$id_investor = (int) clean_text($userdata->{'investorid'});
$id_sub = (int) clean_text($userdata->{'subid'});
//$password = clean_text($userdata ->{'password'});
$office_name = clean_text($userdata->{'officename'});
//$department_name = clean_text($userdata ->{'fullname'});
$phone_number = clean_text($userdata->{'phone'});
$email = clean_text($userdata->{'email'});
$enable = (int) clean_text($userdata->{'enable'});
$last_visit = clean_text($userdata->{'lastvisit'});
$visit_number = (int) clean_text($userdata->{'visitnumber'});
$register_date = clean_text($userdata->{'regdate'});
$permission = clean_text($userdata->{'permission'});
$writable = (int) clean_text($userdata->{'writable'});
$usertype = (int) clean_text($userdata->{'usertype'});
$editable = (int) clean_text($userdata->{'editable'});
//die ($permission);
$sql = 'UPDATE `user`
SET `id_pwc`=' . $id_pwc . ',`id_investor`=' . $id_investor . ',
`id_sub`=' . $id_sub . ',`full_name`="' . $full_name . '",
`office_name`="' . $office_name . '",`phone_number`="' . $phone_number . '",
`email`="' . $email . '",`enable`=' . $enable . ',`last_visit`="' . $last_visit . '",`visit_number`=' . $visit_number . ',
`register_date`="' . $register_date . '",`permission`="' . $permission . '",
`writable`=' . $writable . ',`usertype`=' . $usertype . ',`editable`=' . $editable . ',`flag_change`=1
WHERE `ID`=' . $userid;
// $sql = 'UPDATE `user`
// SET `usergroup`=1,`id_pwc`=1,`id_investor`=1,
// `id_sub`=1,`full_name`="Quốc Đông",`user_name`="quocdong",`password`="202cb962ac59075b964b07152d234b70",
// `office_name`="npc",`department_name`="tdh",`phone_number`="0936668484",
// `email`="*****@*****.**",`enable`=1,`last_visit`="02/04/14 10:55:37",`visit_number`=111,
// `register_date`="02/04/14 10:55:37",`currentpos`="",`token`="03224b341e0ab7c5a2",`permission`="",
// `writable`=1,`usertype`=1,`editable`=1,`cache`=1,
// `cacheall`="",`flag_change`=1,`phongban`="tdh"
// WHERE `ID`='.$userid;
$result = mysql_query($sql) or die(json_encode($returnarray));
$returnarray = array('status' => 200, 'content' => 'Update info succesfully!');
$actioncode = 21;
//update user info profile
$moredetail = 'update userid : ' . $id;
useradminlogs($userid, $actioncode, $moredetail);
echo json_encode($returnarray);
}
function update_userinfo($userid, $info)
{
$returnarray = array('status' => 500, 'content' => 'Create new user fail!');
$userdata = json_decode($info);
$full_name = clean_text($userdata->{'fullname'});
$id_pwc = (int) clean_text($userdata->{'pcid'});
$pcname = clean_text($userdata->{'pcname'});
$id_investor = (int) clean_text($userdata->{'investorid'});
$id_sub = (int) clean_text($userdata->{'subid'});
$user_name = clean_text($userdata->{'username'});
$password = clean_text($userdata->{'password'});
$office_name = clean_text($userdata->{'officename'});
//$department_name = clean_text($userdata ->{'fullname'});
$phone_number = clean_text($userdata->{'phone'});
$email = clean_text($userdata->{'email'});
$enable = (int) clean_text($userdata->{'enable'});
$last_visit = clean_text($userdata->{'lastvisit'});
$visit_number = (int) clean_text($userdata->{'visitnumber'});
$register_date = clean_text($userdata->{'regdate'});
$permission = clean_text($userdata->{'permission'});
$writable = (int) clean_text($userdata->{'writable'});
$usertype = (int) clean_text($userdata->{'usertype'});
$editable = (int) clean_text($userdata->{'editable'});
$register_date = date("d/m/y H:i:s");
$currentpos = 'csdl,csct,0,60,96471056,MK,';
$sql = 'INSERT INTO `user` (`id_pwc`, `id_investor`, `id_sub`, `full_name`, `user_name`, `password`,
`office_name`, `phone_number`, `email`, `currentpos`, `enable`, `register_date`, `permission`,
`writable`,
`usertype`, `editable`, `flag_change`)
VALUES (' . $id_pwc . ',' . $id_investor . ',' . $id_sub . ',"' . $full_name . '","' . $user_name . '",
"' . MD5($password) . '","' . $office_name . '", "' . $phone_number . '","' . $email . '","' . $currentpos . '",
' . $enable . ',"' . $register_date . '","' . $permission . '", ' . $writable . ',' . $usertype . ',' . $editable . ', 1)';
$result = mysql_query($sql) or die(json_encode($returnarray));
$returnarray = array('status' => 200, 'content' => 'Create new user info succesfully!');
$actioncode = 22;
//create new user info profile
$moredetail = 'create username : ' . $user_name;
useradminlogs($userid, $actioncode, $moredetail);
echo json_encode($returnarray);
}
<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: POST, GET, OPTIONS');
header('Access-Control-Max-Age: 1000');
require "libs/config.php";
require "libs/db_functions.php";
require "libs/common_functions.php";
$userid = (int) isset($_REQUEST['userid']) ? $_REQUEST['userid'] : 0;
$actioncode = (int) isset($_REQUEST['actioncode']) ? $_REQUEST['actioncode'] : 0;
$moredetail = isset($_REQUEST['moredetail']) ? $_REQUEST['moredetail'] : '';
CONNECT_DB();
mysql_query("SET NAMES utf8");
$returnarray = array('status' => 500, 'content' => 'Create logs fail!');
$year_production = clean_text($data->{'year_production'});
$timestart_ti = clean_text($data->{'timestart_ti'});
useradminlogs($userid, $actioncode, $moredetail);
$result = mysql_query($sql) or die(json_encode($returnarray));
$returnarray = array('status' => 200, 'content' => 'Create logs succesfully!');
echo json_encode($returnarray);
CLOSE_DB();
unset($sql, $result);
?>
