$coulmns_name = array('shop_name', 'website_url', 'address', 'city', 'pincode', 'email', 'phone_number');
$shop_data_attributes = array();
$columns = '';
$values = '';
// Query builder & attributes filter here.
foreach ($shop_data as $key => $value) {
if (in_array($key, $coulmns_name)) {
$columns = $columns . $key . ',';
$values = $values . "'" . mysql_real_escape_string($value) . "',";
} else {
// To shop attributes fields
$shop_data_attributes[$key] = $value;
}
}
// To convert Local time to GMT.
$date = convertLocalTimezoneToGMT(date('Y-m-d H:i:s'), ini_get('date.timezone'));
$columns = $columns . 'created_at' . ',';
$values = $values . "'" . $date . "',";
$query = "INSERT INTO pos_shop_entity (" . trim($columns, ',') . ") VALUES(" . trim($values, ',') . ")";
$result = mysql_query($query);
if ($result) {
$q = sprintf("SELECT entity_id FROM pos_shop_entity WHERE email='%s' AND is_active= 1 LIMIT 1", mysql_real_escape_string($shop_data->email));
$result = mysql_query($q);
if (!$result) {
die(mysql_error());
} else {
$entity_id = 0;
// Insert and get inserted shop record id.
$num = mysql_num_rows($result);
if ($num) {
while ($row = mysql_fetch_assoc($result)) {
function _insert_user($data)
{
$sql = "SELECT * FROM pos_user_entity WHERE email = '{$data['email']}'";
$result = mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
} else {
if (!mysql_num_rows($result)) {
$username = $data['username'];
$email = $data['email'];
$password = MD5($data['password']);
$cpassword = MD5($data['cpassword']);
$firstname = $data['firstname'];
$lastname = $data['lastname'];
$date = convertLocalTimezoneToGMT(date('Y-m-d H:i:s'), ini_get('date.timezone'));
$role_id = 6;
//Store Admin// (int)$data['role_id'];
$sql = "INSERT INTO pos_user_entity (role_id,firstname,lastname,username,email,password,cpassword,is_adminpanel,created_at,logged_at) VALUES ({$role_id},'{$firstname}','{$lastname}','{$username}','{$email}','{$password}','{$cpassword}',1,'{$date}','{$date}')";
$result = mysql_query($sql);
if ($result) {
$sql = "SELECT entity_id FROM pos_user_entity WHERE email = '{$email}' LIMIT 1";
$result = mysql_query($sql);
$entity_id = 0;
if (mysql_num_rows($result)) {
while ($row = mysql_fetch_assoc($result)) {
$entity_id = $row['entity_id'];
}
}
// To insert into pos_user_validate table , will use to validate user by SUPAER ADMIN.
$sql = "INSERT INTO pos_user_validate (user_id,created_at) VALUES ({$entity_id},'{$date}')";
$result = mysql_query($sql);
$status = array('user_id' => $entity_id, 'statusText' => 'Sucessfully Submitted', 'statusCode' => 200);
echo json_encode($status);
} else {
// Error
$status = array('statusText' => 'Invalid query: ' . mysql_error(), 'statusCode' => 417);
echo json_encode($status);
}
} else {
// all ready exist
$status = array('statusText' => 'Conflict Found', 'statusCode' => 409);
echo json_encode($status);
}
}
}
