public function getCountrySlug()
{
$currencies = [];
$countries = CountryQuery::create()->filterByBorrowerCountry(true)->orderByName()->find();
foreach ($countries as $country) {
$currencies[$country->getSlug()] = $country->getCurrency()->getName() . " in " . $country->getName();
}
return $currencies;
}
public function getBorrowerCountries()
{
$borrowerCountries = CountryQuery::create()->filterByBorrowerCountry(1);
$countries = [];
foreach ($borrowerCountries as $country) {
$countries[$country->getId()] = $country->getName();
}
return $countries;
}
public function getVolunteerMentorCity()
{
$countryCode = \Session::get('BorrowerJoin.countryCode');
$country = CountryQuery::create()->filterByCountryCode($countryCode)->findOne();
$con = Propel::getWriteConnection(TransactionTableMap::DATABASE_NAME);
$sql = "SELECT DISTINCT city FROM borrower_profiles WHERE borrower_id IN " . "(SELECT borrower_id FROM volunteer_mentor WHERE country_id = :country_id AND status = :status\n AND mentee_count < :mentee_count)";
$stmt = $con->prepare($sql);
//TODO to make mentee_count = 50
$stmt->execute(array(':country_id' => $country->getId(), ':status' => '1', ':mentee_count' => '25'));
$cities = $stmt->fetchAll(\PDO::FETCH_COLUMN);
return array_combine($cities, $cities);
}
public function getBorrowersByCountry()
{
$list = [];
$list[0] = null;
$countryCode = \Session::get('BorrowerJoin.countryCode');
$country = CountryQuery::create()->findOneByCountryCode($countryCode);
$borrowers = BorrowerQuery::create()->filterByCountry($country)->orderByFirstName()->filterByActive(true)->joinWith('Profile')->find();
foreach ($borrowers as $borrower) {
$list[$borrower->getId()] = $borrower->getName() . " ( " . $borrower->getProfile()->getCity() . " )";
}
return $list;
}
public function updateExchangeRateForCountry($data)
{
$country = CountryQuery::create()->filterBySlug($data['countrySlug'])->findOne();
$currencyCode = $country->getCurrency()->getCode();
$lastRate = ExchangeRateQuery::create()->filterByCurrencyCode($currencyCode)->filterByEndDate(null)->findone();
if ($lastRate) {
$lastRate->setEndDate(new \DateTime());
$lastRate->save();
}
$newRate = new ExchangeRate();
$newRate->setStartDate(new \DateTime())->setCurrencyCode($currencyCode)->setRate($data['newRate']);
$newRate->save();
return $newRate;
}
public function postCountry()
{
$form = $this->countryForm;
$form->handleRequest(Request::instance());
if ($form->isValid()) {
$country = CountryQuery::create()->findOneById($form->getData()['country']);
Session::put('BorrowerJoin.countryCode', $country->getCountryCode());
Session::put('BorrowerJoin.countryId', $country->getId());
$this->setCurrentStep('facebook');
return Redirect::action('BorrowerJoinController@getFacebook');
}
Flash::error('You can only select from list of available countries.');
return Redirect::action('BorrowerJoinController@getCountry');
}
public static function getCountryCodeByIP()
{
$country['code'] = '';
$country['name'] = '';
$country['id'] = '';
$ip = \Request::getClientIp();
if (!empty($ip)) {
$reader = new Reader(app_path() . '/storage/external/GeoLite2-Country.mmdb');
$record = $reader->country('103.7.80.62');
$country = array();
$country['code'] = $record->country->isoCode;
$country['name'] = $record->country->name;
$dbCountry = CountryQuery::create()->findOneByCountryCode($country['code']);
$country['id'] = $dbCountry->getId();
}
return $country;
}
public function postEditCountry($id)
{
$country = CountryQuery::create()->findOneById($id);
if (!$country) {
\App::abort(404, 'fatal error.');
}
$form = $this->editForm;
$form->handleRequest(Request::instance());
if ($form->isValid()) {
$data = $form->getData();
$country->setBorrowerCountry($data['borrower_country'])->setDialingCode($data['dialing_code'])->setPhoneNumberLength($data['phone_number_length'])->setRegistrationFee($data['registration_fee'])->setInstallmentPeriod($data['installment_period'])->setRepaymentInstructions($data['repayment_instructions']);
$country->save();
\Flash::success('Changes have been updated.');
return Redirect::route('admin:edit:country', $id);
}
\Flash::error('Please use proper options.');
return Redirect::route('admin:edit:country', $id)->withForm($form);
}
public function getCountries()
{
$countries = \Zidisha\Country\CountryQuery::create()->filterByBorrowerCountry(1)->find();
return $countries;
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
try {
$settings = Setting::getAll();
} catch (\Exception $e) {
$settings = [];
}
$model = $this->argument('model');
$size = $this->argument('size');
$faker = Faker::create();
$countries = [['KE', 'Kenya', 'KES', '1000'], ['BJ', 'Benin', 'XOF', '0'], ['BF', 'Burkina Faso', 'XOF', '0'], ['GH', 'Ghana', 'GHS', '0'], ['ID', 'Indonesia', 'IDR', '0'], ['SN', 'Senegal', 'XOF', '0'], ['IN', 'India', 'INR', '0']];
$temp = true;
$allCity = [];
if ($model == 'new') {
$this->line('Rebuild database');
DB::statement('drop schema public cascade');
DB::statement('create schema public');
exec('rm -rf app/database/migrations');
exec('./propel diff');
exec('./propel migrate');
exec('./propel build');
$this->line('Delete loans index');
exec("curl -XDELETE 'http://*****:*****@mail.com';
$user = new \Zidisha\User\User();
$user->setUsername($userName);
$user->setPassword($password);
$user->setEmail($email);
$user->setRole('admin');
$user->setLastLoginAt(new Carbon());
$user->save();
$user = new \Zidisha\User\User();
$user->setUsername('YC');
$user->setPassword('1234567890');
$user->setEmail('*****@*****.**');
$user->setLastLoginAt(new Carbon());
$user->save();
}
if ($model == "Language") {
$languages = [['in', 'Bahasa Indonesia', true], ['fr', 'Français', true], ['hi', 'Hindi', false], ['en', 'English', false]];
foreach ($languages as $language) {
$lang = new Language();
$lang->setLanguageCode($language[0]);
$lang->setName($language[1]);
$lang->setActive($language[2]);
$lang->save();
}
}
if ($model == "CategoryTranslation") {
$allCategories = CategoryQuery::create()->filterByAdminOnly(false)->find();
$allLanguages = \Zidisha\Country\LanguageQuery::create()->filterByActive(true)->find();
foreach ($allCategories as $Category) {
foreach ($allLanguages as $language) {
$translation = new CategoryTranslation();
$translation->setCategory($Category)->setLanguage($language)->setTranslation($Category->getName() . $language->getLanguageCode());
$translation->save();
}
}
}
if ($model == "ExchangeRate") {
foreach (['KES' => 80, 'XOF' => 20, 'GHS' => 50, 'IDR' => 40, 'INR' => 80] as $currencyCode => $rate) {
$dateMonthAgo = new DateTime();
$dateMonthAgo->modify('-1 month');
$dateNow = new DateTime();
$dateNow->modify('-1 second');
$exchangeRate = new \Zidisha\Currency\ExchangeRate();
$exchangeRate->setCurrencyCode($currencyCode)->setRate($rate - 5)->setStartDate($dateMonthAgo)->setEndDate($dateNow);
$exchangeRate->save();
$exchangeRate = new \Zidisha\Currency\ExchangeRate();
$exchangeRate->setCurrencyCode($currencyCode)->setRate($rate)->setStartDate($dateNow);
$exchangeRate->save();
}
}
for ($i = 1; $i <= $size; $i++) {
if ($model == "Invite") {
do {
$lender = $allLenders[array_rand($allLenders->getData())];
$invitee = $allLenders[array_rand($allLenders->getData())];
} while ($lender->getId() == $invitee->getId());
$lenderInvite = new Invite();
$lenderInvite->setLender($lender);
if (is_int($i / 4)) {
$lenderInvite->setEmail($faker->email);
} else {
$lenderInvite->setInvitee($invitee);
$lenderInvite->setInvited(true);
$lenderInvite->setEmail($invitee->getUser()->getEmail());
}
$lenderInvite->save();
}
if ($model == "Lender") {
$userName = '******' . $i;
$password = '******';
$email = 'lender' . $i . '@mail.com';
$oneCountry = $allCountries[array_rand($allCountries->getData())];
$user = new \Zidisha\User\User();
$user->setUsername($userName);
$user->setPassword($password);
$user->setEmail($email);
$user->setRole('lender');
if ($i < 5) {
$user->setLastLoginAt(new Carbon('first day of July 2013'));
} elseif ($i < 10) {
$user->setLastLoginAt(new Carbon('first day of June 2013'));
} else {
$user->setLastLoginAt(new Carbon());
}
$firstName = 'lender' . $i;
$lastName = 'last' . $i;
$lender = new \Zidisha\Lender\Lender();
$lender->setFirstName($firstName);
$lender->setLastName($lastName);
$lender->setCountry($oneCountry);
$lender->setUser($user);
$lender_profile = new \Zidisha\Lender\Profile();
$lender_profile->setAboutMe($faker->paragraph(7));
$lender_profile->setLender($lender);
$lender_profile->save();
}
if ($model == "Borrower") {
$userName = '******' . $i;
$password = '******';
$email = 'borrower' . $i . '@mail.com';
$isMentor = $randArray[array_rand($randArray)];
if ($i <= 40 && $isMentor) {
$oneCountry = $allCountries[3];
} else {
$oneCountry = $allCountries[array_rand($allCountries->getData())];
}
$user = new \Zidisha\User\User();
$user->setUsername($userName);
$user->setPassword($password);
$user->setEmail($email);
$user->setLastLoginAt(new Carbon());
$user->setRole('borrower');
$firstName = 'borrower' . $i;
$lastName = 'last' . $i;
$borrower = new \Zidisha\Borrower\Borrower();
$borrower->setFirstName($firstName);
$borrower->setLastName($lastName);
if ($isMentor) {
$oneCountry = $allCountries[2];
}
$borrower->setCountry($oneCountry);
$borrower->setUser($user);
$borrower->setVerified($faker->boolean());
foreach (['communityLeader', 'familyMember', 'familyMember', 'familyMember', 'neighbor', 'neighbor', 'neighbor'] as $contactType) {
$contact = new \Zidisha\Borrower\Contact();
$contact->setPhoneNumber($faker->numberBetween(100000000, 1000000000))->setFirstName($faker->firstName)->setLastName($faker->lastName)->setDescription($faker->sentence())->setType($contactType);
$borrower->addContact($contact);
}
$borrower_profile = new \Zidisha\Borrower\Profile();
$borrower_profile->setAboutMe($faker->paragraph(7));
$borrower_profile->setAboutBusiness($faker->paragraph(7));
$borrower_profile->setAddress($faker->paragraph(3));
$borrower_profile->setAddressInstructions($faker->paragraph(6));
if ($isMentor) {
$borrower_profile->setCity("Experimento");
} elseif ($i <= 20) {
$city = $faker->city;
array_push($allCity, $city);
$borrower_profile->setCity($city);
} else {
$borrower_profile->setCity($allCity[array_rand($allCity)]);
}
$borrower_profile->setPhoneNumber($faker->phoneNumber);
$borrower_profile->setAlternatePhoneNumber($faker->phoneNumber);
$borrower_profile->setNationalIdNumber($faker->randomNumber(10));
$borrower_profile->setBorrower($borrower);
if ($i <= 40) {
$user->setSubRole('volunteerMentor');
$mentor = new VolunteerMentor();
$borrower->setCountry($allCountries[2]);
$mentor->setBorrowerVolunteer($borrower)->setCountry($borrower->getCountry())->setStatus(1)->setGrantDate(new \DateTime());
} else {
$allMentors = VolunteerMentorQuery::create()->find();
$oneMentor = $allMentors[array_rand($allMentors->getData())];
$borrower->setVolunteerMentor($oneMentor);
}
$borrower_profile->save();
$joinLog = new JoinLog();
$joinLog->setIpAddress($faker->ipv4)->setVerificationCode($faker->randomNumber(20))->setBorrower($borrower);
if ($borrower->getVerified()) {
$joinLog->setVerifiedAt(new \DateTime());
}
$joinLog->save();
}
if ($model == "Country") {
if ($i > sizeof($countries)) {
continue;
}
$oneCountry = $countries[$i - 1];
$country = new Country();
$country->setName($oneCountry[1]);
$country->setCountryCode($oneCountry[0]);
$country->setContinentCode('AF');
$country->setDialingCode('000');
$country->SetRegistrationFee($oneCountry[3]);
$country->SetBorrowerCountry(true);
$country->setCurrencyCode($oneCountry[2]);
$country->setPhoneNumberLength(9);
$country->setInstallmentPeriod($faker->randomElement([Loan::WEEKLY_INSTALLMENT, Loan::MONTHLY_INSTALLMENT]));
if ($i < 3) {
$language = \Zidisha\Country\LanguageQuery::create()->filterByLanguageCode('fr')->findOne();
$country->setLanguage($language);
} elseif ($i > 2) {
$language = \Zidisha\Country\LanguageQuery::create()->filterByLanguageCode('in')->findOne();
$country->setLanguage($language);
}
$country->save();
}
if ($model == "Category") {
if ($i >= 17) {
continue;
}
$oneCategory = $categories[$i - 1];
$category = new Category();
$category->setName($oneCategory[0]);
$category->setWhatDescription($oneCategory[1]);
$category->setWhyDescription($oneCategory[2]);
$category->setHowDescription($oneCategory[3]);
$category->setAdminOnly($oneCategory[4]);
$category->save();
}
if ($model == "Loan") {
if ($i >= 30) {
$installmentDay = $i - (int) (25 - $i);
$amount = 30 + $i * 100;
} else {
$installmentDay = $i;
$amount = 30 + $i * 200;
}
$loanCategory = $allCategories[array_rand($allCategories)];
$status = floatval($size / 7);
if ($i > 50 && $i < 55) {
$borrower = $allBorrowers[50];
} else {
$borrower = $allBorrowers[$i - 1];
}
$data = array();
$data['summary'] = $faker->sentence(8);
$data['proposal'] = $faker->paragraph(7);
$data['nativeAmount'] = $amount;
$data['currencyCode'] = 'KES';
$data['amount'] = $amount / 2;
$installmentAmount = (int) $data['amount'] / 12;
$data['installmentAmount'] = $installmentAmount;
$data['registrationFeeRate'] = '5';
$data['applicationDate'] = new \DateTime();
$data['installmentDay'] = $installmentDay;
$data['categoryId'] = $loanCategory->getId();
$data['amountRaised'] = 40;
if ($i < $status) {
$data['amountRaised'] = 0;
$loanService->applyForLoan($borrower, $data);
continue;
}
$Loan = Loan::createFromData($data);
$Loan->setCategory($loanCategory);
$Loan->setBorrower($borrower);
$Stage = new Stage();
$Stage->setLoan($Loan);
$Stage->setBorrower($borrower);
if ($i < $status * 3) {
$borrower->setLoanStatus(Loan::FUNDED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::FUNDED);
$Loan->setNativeDisbursedAmount($amount);
$Loan->setDisbursedDate(new \DateTime());
$Stage->setStatus(Loan::FUNDED);
} elseif ($i < $status * 4) {
$borrower->setLoanStatus(Loan::ACTIVE);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::ACTIVE);
$Loan->setAmountRaised($amount - $amount / 3);
$Loan->setDisbursedDate(new \DateTime());
$Stage->setStatus(Loan::ACTIVE);
} elseif ($i < $status * 5) {
$borrower->setLoanStatus(Loan::REPAID);
$borrower->setActiveLoan($Loan);
$Loan->setNativeDisbursedAmount($amount);
$Loan->setDisbursedDate(strtotime("-1 year"));
$Loan->setStatus(Loan::REPAID);
$Stage->setStatus(Loan::REPAID);
} elseif ($i < $status * 6) {
$borrower->setLoanStatus(Loan::DEFAULTED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::DEFAULTED);
$Stage->setStatus(Loan::DEFAULTED);
} elseif ($i < $status * 7) {
$borrower->setLoanStatus(Loan::CANCELED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::CANCELED);
$Stage->setStatus(Loan::CANCELED);
} else {
$borrower->setLoanStatus(Loan::EXPIRED);
$borrower->setActiveLoan($Loan);
$Loan->setStatus(Loan::EXPIRED);
$Stage->setStatus(Loan::EXPIRED);
}
$Stage->setStartDate(new \DateTime());
$Stage->save();
$borrower->save();
$loanService->addToLoanIndex($Loan);
}
if ($model == "Transaction") {
$oneLender = $allLenders[array_rand($allLenders->getData())];
$oneLoan = $allLoans[array_rand($allLoans->getData())];
$transaction = new Transaction();
$transaction->setUser($oneLender->getUser());
$transaction->setAmount(Money::create(rand(-100, 200), 'USD'));
$transaction->setLoan($oneLoan);
$transaction->setDescription('description');
$transaction->setTransactionDate(new \DateTime());
$transaction->setType(Transaction::FUND_WITHDRAW);
$transaction->save();
if ($temp == true) {
$yc = \Zidisha\User\UserQuery::create()->findOneById(2);
$transaction = new Transaction();
$transaction->setUser($yc);
$transaction->setAmount(Money::create(10000, 'USD'));
$transaction->setDescription($faker->sentence(4));
$transaction->setTransactionDate(new \DateTime());
$transaction->setType(Transaction::DONATE_BY_ADMIN);
$transaction->save();
$temp = false;
}
}
if ($model == "Bid") {
$openLoans = LoanQuery::create()->filterByStatus(0)->find();
$oneLoan = $openLoans[array_rand($openLoans->getData())];
$oneLender = $allLenders[array_rand($allLenders->getData())];
$oneBid = new Bid();
$oneBid->setBidDate(new \DateTime());
$oneBid->setBidAmount(Money::create(rand(0, 30), 'USD'));
$oneBid->setInterestRate(rand(0, 15));
$oneBid->setLoan($oneLoan);
$oneBid->setLender($oneLender);
$oneBid->setBorrower($oneLoan->getBorrower());
$oneBid->save();
}
if ($model == "Comment") {
$borrower = $allBorrowers[array_rand($allBorrowers)];
$user = $allBorrowers[array_rand($allBorrowers)];
$isTranslated = $randArray[array_rand($randArray)];
$comment = new Comment();
$comment->setBorrower($borrower)->setUser($user->getUser())->setMessage($faker->paragraph(3))->setLevel(0);
if ($isTranslated) {
$comment->setMessageTranslation($faker->paragraph(3))->setTranslatorId(1);
} elseif ($i < 100) {
$comment->setUser($borrower->getUser());
}
$comment->save();
}
if ($model == "GiftCard") {
$lender = $allLenders[array_rand($allLenders->getData())];
$amount = Money::create(rand(15, 1000), 'USD');
$faker = Faker::create();
$isClaimed = $randArray[array_rand($randArray)];
$giftCard = new GiftCard();
$giftCard->setLender($lender)->setOrderType(array_rand([0, 1]))->setCardAmount($amount)->setFromName($lender->getName())->setMessage($faker->sentence(10))->setRecipientEmail($faker->email)->setDate(new \DateTime())->setExpireDate(strtotime('+1 year'))->setCardCode($faker->creditCardNumber);
if ($isClaimed) {
$recipient = $allLenders[array_rand($allLenders->getData())];
$giftCard->setClaimed(1)->setRecipientName($recipient->getName())->setRecipient($recipient);
}
$giftCard->save();
}
if ($model == "LenderGroup") {
$leader = $allLenders[array_rand($allLenders->getData())];
$group = new LendingGroup();
$group->setCreator($leader)->setLeader($leader)->setCreator($leader)->setAbout($faker->paragraph(2))->setName($faker->sentence(2));
$groupMember = new LendingGroupMember();
$groupMember->setMember($leader)->setLendingGroup($group);
$groupMember->save();
}
if ($model == "LenderGroupMember") {
$member = $allLenders[array_rand($allLenders->getData())];
$group = $allGroups[array_rand($allGroups->getData())];
$groupMember = new LendingGroupMember();
$groupMember->setMember($member)->setLendingGroup($group);
$groupMember->save();
}
}
}
public function getCountries()
{
return CountryQuery::create()->orderByName()->find()->toKeyValue('id', 'name');
}
public function getPage()
{
$countries = CountryQuery::create()->filterByBorrowerCountry(true)->find();
return View::make('pages.borrow', compact('countries'));
}
public function filterBorrowerLanguages()
{
$languageCodes = CountryQuery::create()->filterByBorrowerCountry(true)->distinct()->select(['language_code'])->find();
return $this->filterByLanguageCode($languageCodes->getData());
}
