public function getSendMsgUrl($phone, $content)
{
$url['username'] = getenv('SEND_MSG_SNAME');
if (empty($url['username'])) {
return false;
}
$url['password'] = getenv('SEND_MSG_SPWD');
if (empty($url['password'])) {
return false;
}
// $url['scorpid'] = getenv('SEND_MSG_SCORPID');
// $url['sprdid'] = getenv('SEND_MSG_SPRDID');
// if (empty($url['sprdid'])) {
// return false;
// }
$url['mobile'] = $phone;
$url['smscontent'] = $content;
$curl = getenv('SEND_MSG_URL') . '?' . http_build_query($url);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $curl);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HEADER, 0);
$output = curl_exec($ch);
curl_close($ch);
\Log::info($output);
return true;
}
public static function getReviewAbleUser($userId)
{
\Log::info("in get notification function");
$collection = DB::Table('borrowHistory')->select('borrowHistory.ownedBookListId', 'borrowHistory.borrowerId', 'borrowHistory.borrowDate', 'borrowHistory.returnDate', 'ownedBookList.userId', 'bookinfo.bookid', 'bookinfo.bookName', 'user.userFullName', 'reputation.RecipientId', 'reputation.point')->join('ownedBooklist', 'ownedBooklist.ownedBooklistId', '=', 'borrowHistory.ownedBooklistId')->join('user', 'user.id', '=', 'borrowHistory.borrowerId')->join('bookinfo', 'ownedBooklist.bookid', '=', 'bookinfo.bookid')->join('reputation', 'reputation.RecipientId', '=', 'borrowHistory.borrowerId')->where('ownedBooklist.userId', $userId);
// $collection = $collection->orderby('');
$notifications = $collection->get();
$query = DB::Table('borrowHistory')->select('borrowHistory.borrowerId')->join('ownedBooklist', 'ownedBooklist.ownedBooklistId', '=', 'borrowHistory.ownedBooklistId')->where('ownedBooklist.userId', $userId);
$data = $query->distinct()->get();
\Log::info($data);
\Log::info(".........borrwoer ids");
$query = "";
$query = DB::Table('user')->select('user.userFullName', 'user.id');
for ($i = 0; $i < count($data); $i++) {
if ($i == 0) {
$query->where('user.Id', $data[$i]->borrowerId);
} else {
$query->orwhere('user.Id', $data[$i]->borrowerId);
}
}
$data = $query->get();
\Log::info($data);
\Log::info(".......in get notification function returning");
return $data;
// $notifications = "alamin";
// return $notifications;
}
public static function updateReputaionTable($obli, $bi, $point)
{
$collection = DB::Table('reputation')->select('*')->where('userId', $obli)->where('recipientId', $bi);
$notifications = $collection->get();
if (count($notifications) == 0) {
DB::insert("INSERT INTO `reputation` (`UserID`, `RecipientId`, `Point`)\n VALUES (?, ?, ?)", [$obli, $bi, $point]);
} else {
DB::table('reputation')->where('userId', $obli)->where('recipientId', $bi)->update(['point' => $point]);
}
\Log::info($notifications);
\Log::info("........trying to update b.....reputation");
}
public static function getAuthorId($AuthorName)
{
$BookId = DB::select(' select AuthorId ' . ' from authors ' . ' where AuthorName = ?; ', [$AuthorName]);
// \Log::info ($BookId);
// $temp = 5;
// foreach ($BookId as $user) {
// // echo '<li class="list-group-item">' .$user->empname . " ............... "
// // ."</li>";
// $temp = $user->BookId;
// break;
// }
$temp = $BookId[0]->AuthorId;
\Log::info($temp);
return $temp;
\Log::info("in the function authorName");
}
public static function getOwnedBooklistIdByLocation($Location)
{
// \Log::info("........in searchbook model ");
\Log::info($Location);
\Log::info(".....above is locationName");
$query = DB::Table('Locations')->select('ownedBooklocations.ownedBookListId')->join('ownedBooklocations', 'locations.locationid', '=', 'ownedBooklocations.locationid');
for ($i = 0; $i < count($Location); $i++) {
if ($i == 0) {
$query->where('Locations.locationName', 'like', '%' . $Location[$i] . '%');
} else {
$query->orwhere('Locations.locationName', 'like', '%' . $Location[$i] . '%');
}
}
$data = $query->get();
return $data;
}
public static function addToBookInfoCategory($bookId, $CategoryName)
{
$query = DB::table('category')->select('categoryId');
for ($i = 0; $i < count($CategoryName); $i++) {
if ($i == 0) {
$query->where('CategoryName', $CategoryName[$i]);
} else {
$query->orwhere('CategoryName', $CategoryName[$i]);
}
}
$categoryId = $query->get();
\Log::info($categoryId);
\Log::info("......categoryIds.");
for ($i = 0; $i < count($categoryId); $i++) {
DB::insert("INSERT INTO `bookinfocategory` (`BookId`, `CategoryId`)\n VALUES (?, ?);", [$bookId, $categoryId[$i]->categoryId]);
}
}
public static function insertToBorrowHistoryTable($obli, $bi, $days)
{
\Log::info("trying to insernt in borrowhistory table form book model");
BookInsertModel::insertToBorrowHistoryTable($obli, $bi, $days);
}
