setOrderCustomer($order, $customer);
$customer = createCustomer('DUMON', '15b242e7-52eb-46bd-8f0e-6568b72cd9a6', 'Janine Labrune', null, 'France', 4);
$customers[] = $customer;
$order = createOrder(125, '1995-05-05', '1995-05-09', 'Federal Shipping', 100, 1, 800);
$orders[] = $order;
setCustomerOrder($customer, $order);
setOrderCustomer($order, $customer);
$order = createOrder(126, '1999-07-16', '1999-08-20', 'Speedy Express', 80, 2, 150);
$orders[] = $order;
setCustomerOrder($customer, $order);
setOrderCustomer($order, $customer);
$order = createOrder(126, '2008-08-16', '2009-08-22', 'United Package', 88, 6, 50);
$orders[] = $order;
setCustomerOrder($customer, $order);
setOrderCustomer($order, $customer);
$customer = createCustomer('EASTC', '15b242e7-52eb-46bd-8f0e-6568b72cd9a7', 'Ann Devon', createAddress('FF45', 15, 16, '35 King George', true, false), 'Germany', 3);
$customers[] = $customer;
print_r($customers);
function createAddress($houseNumber, $lineNumber, $lineNumber2, $streetName, $isValid, $isPrimary)
{
$address = new Address4();
$address->Address2 = new Address2();
$address->Address2->IsPrimary = $isPrimary;
$address->HouseNumber = $houseNumber;
$address->IsValid = $isValid;
$address->LineNumber = $lineNumber;
$address->LineNumber2 = $lineNumber2;
$address->StreetName = $streetName;
return $address;
}
function createCustomer($customerID, $customerGuid, $customerName, $address, $country, $rating)
if (empty($args['adress']['adress'])) {
array_push($errors, 'No adress set!');
}
if (empty($args['adress']['postalCodeNumbers']) || empty($args['adress']['postalCodeLetters'])) {
array_push($errors, 'No postal code set!');
}
if (empty($args['adress']['city'])) {
array_push($errors, 'No city set!');
}
if (empty($args['adress']['country'])) {
array_push($errors, 'No country set!');
}
if (!empty($errors)) {
createResponse($errors);
} else {
createResponse(array('id' => createCustomer($args)));
}
});
//////////////////////
// //
// Rentals //
// //
//////////////////////
$app->get('/customer/rentals/{id}', function ($request, $response, $args) {
if ($rentalData = getrentalsFromUser($args['id'])) {
$rentals = array();
while ($rental = mysqli_fetch_array($rentalData)) {
array_push($rentals, editRental($rental));
}
createResponse($rentals);
} else {
$material = createMaterials($con);
$color = createColors($con);
$brands = createBrands($faker, $con);
$folders = createFolders($faker, $con);
$contents = createContents($faker, $folders, $con);
$categories = createCategories($faker, $con);
echo "creating templates\n";
$template = new \Thelia\Model\Template();
$template->setLocale('fr_FR')->setName('template de démo')->setLocale('en_US')->setName('demo template')->save($con);
$at = new Thelia\Model\AttributeTemplate();
$at->setTemplate($template)->setAttribute($color)->save($con);
$ft = new Thelia\Model\FeatureTemplate();
$ft->setTemplate($template)->setFeature($material)->save($con);
echo "end creating templates\n";
createProduct($faker, $categories, $brands, $contents, $template, $color, $material, $con);
createCustomer($faker, $con);
// set some config key
createConfig($faker, $folders, $contents, $con);
$con->commit();
} catch (Exception $e) {
echo "error : " . $e->getMessage() . "\n";
$con->rollBack();
}
function createProduct($faker, $categories, $brands, $contents, $template, $attribute, $feature, $con)
{
echo "start creating products\n";
$fileSystem = new \Symfony\Component\Filesystem\Filesystem();
if (($handle = fopen(THELIA_ROOT . '/setup/import/products.csv', "r")) !== FALSE) {
$row = 0;
while (($data = fgetcsv($handle, 100000, ";")) !== FALSE) {
$row++;
}
$DataCSVFile = "wecaredata3.csv";
$dataDir = "/home/ubuntu/data/doc3/";
if (!validateDirStr($dataDir)) {
die("\n invalid File Structure\n");
}
$config['host'] = "localhost";
$config['user'] = "******";
$config['password'] = "******";
$config['database'] = "bluenet_v3";
$db_handle = mysqli_connect($config['host'], $config['user'], $config['password'], $config['database']);
if (($handle = fopen($DataCSVFile, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$lName = $data[8];
$lMobile = $data[9];
$lAddress = $data[4];
$localId = $data[0];
$wName = $data[1];
$wMobile = $data[2];
$wAddress = $data[7];
$service = $data[6];
$emergency_no = $data[3];
$native_add = $data[5];
$refId = createCustomer($db_handle, $lName, $lMobile, $lAddress);
$outArray = UploadDocs($dataDir, $localId);
$wId = createCustomerWorker($db_handle, $wName, $wMobile, $wAddress, $outArray['photo'], $refId, $localId, $service, $outArray['pv'], $outArray['adhar_card'], $outArray['voter_card'], $outArray['driving_license'], $outArray['pan_card'], $emergency_no, $native_add);
echo $wId . ",";
}
fclose($handle);
}
mysqli_close($db_handle);
$address->state = $_GET["State"];
$address->zip = preg_replace('/[^0-9]/', '', $_GET["Zip"]);
$address->country = "USA";
$validCardHolder = new HpsCardHolder();
$validCardHolder->firstName = $_GET["FirstName"];
$validCardHolder->lastName = $_GET["LastName"];
$validCardHolder->address = $address;
$validCardHolder->phoneNumber = preg_replace('/[^0-9]/', '', $_GET["PhoneNumber"]);
$validCardHolder->emailAddress = $_GET['Email'];
$suToken = new HpsTokenData();
$suToken->tokenValue = isset($_GET['token_value']) ? $_GET['token_value'] : '';
$suToken->lastFour = isset($_GET['card_last_four']) ? $_GET['card_last_four'] : '';
$amount = $_GET['payment_amount'];
$customerKey = null;
$paymentMethodKey = null;
$scheduleKey = null;
try {
$customerKey = createCustomer($payPlanService, $validCardHolder);
$paymentMethodKey = createPaymentMethod($payPlanService, $customerKey, $validCardHolder, $suToken);
$scheduleKey = createSchedule($payPlanService, $customerKey, $paymentMethodKey, $amount);
} catch (HpsException $e) {
die($e->getMessage());
}
$body = '<h1>Success!</h1>';
$body .= '<p>Thank you, ' . $_GET['FirstName'] . ', for your subscription.';
printf('customerKey: %s<br />', $customerKey);
printf('paymentMethodKey: %s<br />', $paymentMethodKey);
printf('scheduleKey: %s<br />', $scheduleKey);
// i'm running windows, so i had to update this:
//ini_set("SMTP", "my-mail-server");
//SendEmail($_GET['Email'], '*****@*****.**', 'Successful Charge!', $body, true);
Fixtures::add('news', $news);
$findOrders = function () use($app) {
return $app['orm.em']->getRepository('Eccube\\Entity\\Order')->createQueryBuilder('o')->where('o.del_flg = 0')->getQuery()->getResult();
};
/** 受注を検索するクロージャ. */
Fixtures::add('findOrders', $findOrders);
$findProducts = function () use($app) {
return $app['orm.em']->getRepository('Eccube\\Entity\\Product')->createQueryBuilder('p')->where('p.del_flg = 0')->getQuery()->getResult();
};
/** 商品を検索するクロージャ. */
Fixtures::add('findProducts', $findProducts);
$createCustomer = function ($email = null, $active = true) use($app, $faker) {
if (is_null($email)) {
$email = microtime(true) . '.' . $faker->safeEmail;
}
return createCustomer($app, $email, $active);
};
/** 会員を生成するクロージャ. */
Fixtures::add('createCustomer', $createCustomer);
$createOrders = function ($Customer, $numberOfOrders = 5) use($app, $faker) {
$Orders = array();
for ($i = 0; $i < $numberOfOrders; $i++) {
$Order = $app['eccube.fixture.generator']->createOrder($Customer);
$Status = $app['eccube.repository.order_status']->find($faker->numberBetween(1, 7));
$OrderDate = $faker->dateTimeThisYear();
$Order->setOrderStatus($Status);
$Order->setOrderDate($OrderDate);
$app['orm.em']->flush($Order);
$Orders[] = $Order;
}
return $Orders;
$sql = "INSERT INTO `bluenet_v3`.`workers` (`id`, `ref_id`, `user_id`, `status`, `emergency_no`, `native_place`,\n\t\t\t\t\t\t\t\t`native_add`, `dob`, `education`, `experience`, `gender`, `remark`, `salary`, `local_id`)\n\t\t\t\tVALUES (NULL,\n\t\t\t\t\t'" . $refId . "',\n\t\t\t\t\t'" . $uwId . "',\n\t\t\t\t\t 'recruited',\n\t\t\t\t\t '" . $emergency_no . "',\n\t\t\t\t\t '',\n\t\t\t\t\t '" . $native_add . "',\n\t\t\t\t\t\t'',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t '',\n\t\t\t\t\t\t\t'',\n\t\t\t\t\t\t\t '" . $localId . "');";
mysqli_query($db_handle, $sql);
$wId = mysqli_insert_id($db_handle);
//echo $wId. "\n";
if ($wId == 0 || $wId == null) {
echo " Error: " . mysqli_error($db_handle);
die;
}
$sId = array('maid' => 1, 'cook' => 2, 'car cleaner' => 15);
//5. adding worker service
$sql = "INSERT INTO `bluenet_v3`.`service_worker_mappings`\n\t\t\t\t(`id`, `worker_id`, `service_id`)\n\t\t\t\t\tVALUES ('',\n\t\t\t\t\t'" . $wId . "',\n\t\t\t\t\t '" . $sId[$service] . "'\n\t\t\t\t\t );";
mysqli_query($db_handle, $sql);
//6. adding worker society mapping
$sql = "INSERT INTO `bluenet_v3`.`society_worker_mapping`\n\t\t\t\t(`worker_id`, `society_id`)\n\t\t\t\t\tVALUES (\n\t\t\t\t\t'" . $wId . "',\n\t\t\t\t\t '" . $society . "'\n\t\t\t\t\t );";
mysqli_query($db_handle, $sql);
return $uwId;
}
function createDocUid($dbHandle, $uwId, $pvUid, $adharCardUid, $voterCardUid, $drivingLicenseUid, $panCardUid)
{
$sql = "INSERT INTO `bluenet_v3`.`user_documents_uid` (`id`, `user_id`, `pv_uid`, `adhar_card_uid`, `voter_id_uid`, `driving_license_uid`, `pan_card_uid`)\n\t\t\t\tVALUES (NULL,\n\t\t\t\t\t'" . $uwId . "',\n\t\t\t\t\t'" . $pvUid . "',\n\t\t\t\t\t '" . $adharCardUid . "',\n\t\t\t\t\t '" . $voterCardUid . "',\n\t\t\t\t\t '" . $drivingLicenseUid . "',\n\t\t\t\t\t\t'" . $panCardUid . "');";
return mysqli_query($dbHandle, $sql);
}
$refId = createCustomer($db_handle, $input->root->resident_name, $input->root->resident_mobile, $input->root->resident_address, $route[2]);
if ($refId != 0) {
$wId = createCustomerWorker($db_handle, $input->root->worker_name, $input->root->worker_mobile, $input->root->worker_address, $input->root->worker_photo, $refId, $input->root->worker_localId, $input->root->worker_service, $input->root->worker_pv, $input->root->worker_ac, $input->root->worker_vc, $input->root->worker_dl, $input->root->worker_pc, $input->root->worker_emergency_no, $input->root->worker_native_add, $route[2]);
createDocUid($db_handle, $wId, $input->root->worker_pv_uid, $input->root->worker_ac_uid, $input->root->worker_vc_uid, $input->root->worker_dl_uid, $input->root->worker_pc_uid);
//echo $refId." ".$wId.",";
$input->root->resident_id = $refId;
$input->root->worker_id = $wId;
}
print json_encode($input);
function post_data($values)
{
$servername = "localhost";
$username = "******";
$password = "";
$db_name = "versono_db";
$isSuccess = True;
// Create connection
$conn = new mysqli($servername, $username, $password, $db_name);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$errorNum = 0;
$errorMsg = "";
$sql = $conn->prepare("INSERT INTO versono_user(email, first_name, last_name, user_password, address, city, state, zip_code, stripe_customer_id) VALUES (?,?,?,?,?,?,?,?,?)");
if ($sql == False) {
$isSuccess = False;
} else {
$sql->bind_param('sssssssss', $values[0], $values[1], $values[2], hash("sha256", $values[3], False), $values[4], $values[5], $values[6], $values[7], createCustomer($values[8]));
if ($sql->execute() === True) {
# success
} else {
$isSuccess = False;
if ($sql->errno === 1062) {
$errorNum = 1062;
$errorMsg = "Signup failed :(";
}
}
$sql->close();
}
$conn->close();
return array($isSuccess, $errorNum, $errorMsg);
}
