public static function add($name, $tin_number, $address_1, $address_2, $landmark, $city, $state, $pincode, $phone, $fax, $email, $website, $description) { // opening db connection $db = new Connection(); $conn = $db->connect(); //user details $userId = $_SESSION['user']['id']; $username = $_SESSION['user']['username']; $sql = "INSERT INTO `company`( `name`, `tin_number`, `address_1`, `address_2`, `landmark`, `city`, `state`, `pincode`, `phone`, `fax`, `email`, `website`, `admin_user`, `description`) VALUES ('{$name}', '{$tin_number}', '{$address_1}', '{$address_2}', '{$landmark}', '{$city}', '{$state}', '{$pincode}', '{$phone}', '{$fax}', '{$email}', '{$website}', '{$userId}', '{$description}')"; /*if($conn != null) echo "1111<br>";*/ if (mysqli_query($conn, $sql)) { $getCompany = "SELECT id FROM company WHERE name='{$name}' AND tin_number='{$tin_number}' AND website='{$website}'"; $action = mysqli_query($conn, $getCompany); if (mysqli_num_rows($action) > 0) { while ($row = mysqli_fetch_assoc($action)) { $companyId = $row['id']; $_SESSION['user']['company'] = $companyId; $mUser = new User(); $mUser->setCompany($companyId); $mUser->updateCompanyToVehicle(); $mUser->updateCompanyToNotification(); $mUser->updateCompanyToDriver(); return true; } } else { return false; } } else { //echo mysqli_error($conn); return false; } }
public function configureUser() { $_response = User::login(request_var('cmbCompany'), request_var('userId')); if (is_array($_response) && count($_response)) { session_init(); $objUser = new User(); $objUser->setId($_response["ParticipanteId"]); $objUser->setIdentification($_response["Identificacion"]); $objUser->setFirstName($_response["Nombre"]); $objUser->setLastName($_response["Apellido"]); $objUser->setFullName($_response["Nombre"] . " " . $_response["Apellido"]); $objUser->setUsername($_response["UsuarioId"]); $objUser->setCompany(request_var('cmbCompany')); $objUser->setOffice(request_var("cmbOffice")); set_session_var(VAR_USER, $objUser); send_redirect("../view/main/master.php"); } }
static function addUserToSite($db_users, $siteid, $name, $email, $company, $password) { if (!$password) { return new Result(Result::$OK, NULL); } $result = $db_users->getUserByEmail($email); if ($result->isOK()) { $user = $result->getReturnedObj(); $newIds = $user->getSiteIds(); $newIds[] = $siteid; $user->setSiteIds($newIds); $result = $db_users->updateUser($user); } else { $user = new User(); $user->setName($name); $user->setEmail($email); $user->setCompany($company); $user->setSiteIds(array($siteid)); $user->setPassword($password); $user->setRawAcl(''); $result = $db_users->addUser($user); } return $result; }
<?php require_once "bootstrap.php"; require_once "src/User.php"; $login = $argv[1]; $name = $argv[2]; $surname = $argv[3]; $team = $argv[4]; $company = $argv[5]; echo "Created User with login " . $login . "\n"; echo "Created User with name " . $name . "\n"; echo "Created User with surname " . $surname . "\n"; echo "Created User with team " . $team . "\n"; echo "Created User with company " . $company . "\n"; $user = new User($login); $user->setName($name); $user->setSurname($surname); $user->setTeam($team); $user->setCompany($company); $entityManager->persist($user); $entityManager->flush(); echo "Created User with ID " . $user->getId() . "\n";