static function saveLent($option, $bids, $task = "") { global $database, $Itemid; PHP_booklibrary::addTitleAndMetaTags(); $checkB = mosGetParam($_REQUEST, 'checkbook'); if ($checkB != "on") { echo "<script> alert('Select an item to Lend'); window.history.go(-1);</script>\n"; exit; } $data = JFactory::getDBO(); $bookid = mosGetParam($_REQUEST, 'bookid'); $id = mosGetParam($_REQUEST, 'id'); $lend_from = mosGetParam($_REQUEST, 'lend_from'); $lend_until = mosGetParam($_REQUEST, 'lend_until'); if (!is_array($bids) || count($bids) < 1) { echo "<script> alert('Select an item to lend'); window.history.go(-1);</script>\n"; exit; } $lend = new mosBookLibrary_lend($database); if ($task == "edit_lend") { $lend->load($bids[0]); } $query = "SELECT * FROM #__booklibrary_lend where fk_bookid = " . $id . " AND lend_return is NULL "; $data->setQuery($query); $lendTerm = $data->loadObjectList(); if ($lend_from > $lend_until) { echo "<script> alert('" . $lend_from . " more then " . $lend_until . "'); window.history.go(-1); </script>\n"; exit; } $lend_from = substr($lend_from, 0, 10); $lend_until = substr($lend_until, 0, 10); if (isset($lendTerm[0])) { for ($e = 0, $m = count($lendTerm); $e < $m; $e++) { if ($task == "edit_lend" && $bids[0] == $lendTerm[$e]->id) { continue; } $lendTerm[$e]->lend_from = substr($lendTerm[$e]->lend_from, 0, 10); $lendTerm[$e]->lend_until = substr($lendTerm[$e]->lend_until, 0, 10); //check lend if ($lend_from >= $lendTerm[$e]->lend_from && $lend_from <= $lendTerm[$e]->lend_until || $lend_from <= $lendTerm[$e]->lend_from && $lend_until >= $lendTerm[$e]->lend_until || $lend_until >= $lendTerm[$e]->lend_from && $lend_until <= $lendTerm[$e]->lend_until) { echo "<script> alert('Sorry, this item already lend out from " . $lendTerm[$e]->lend_from . " until " . $lendTerm[$e]->lend_until . "'); window.history.go(-1); </script>\n"; exit; } } } //if end if (mosGetParam($_REQUEST, 'lend_from') != "") { $lend->lend_from = data_transformer(mosGetParam($_REQUEST, 'lend_from'), "to"); } else { $lend->lend_from = null; } if (mosGetParam($_REQUEST, 'lend_until') != "") { $lend->lend_until = data_transformer(mosGetParam($_REQUEST, 'lend_until'), "to"); } else { $lend->lend_until = null; } $lend->fk_bookid = $id; $userid = mosGetParam($_REQUEST, 'userid'); if ($userid == "-1") { $lend->user_name = mosGetParam($_REQUEST, 'user_name', ''); $lend->user_email = mosGetParam($_REQUEST, 'user_email', ''); } else { $lend->fk_userid = $userid; } if (!$lend->check($lend)) { echo "<script> alert('" . $lend->getError() . "'); window.history.go(-1); </script>\n"; exit; } if (!$lend->store()) { echo "<script> alert('" . $lend->getError() . "'); window.history.go(-1); </script>\n"; exit; } $lend->checkin(); $book = new mosBooklibrary($database); $book->load($id); $book->fk_lendid = $lend->id; $book->store(); $book->checkin(); if ($option == 'com_comprofiler') { $link_for_mosRedirect = "index.php?option=" . $option . "&tab=getmybooksTab&Itemid=" . $Itemid; } else { $link_for_mosRedirect = "index.php?option=" . $option . "&view=show_my_books&layout=mybooks"; } //print_r($link_for_mosRedirect);exit; //mosRedirect($link_for_mosRedirect); PHP_booklibrary::showMyBooks($option); }
function saveLend_return($option, $lids) { global $database, $my; $id = mosGetParam($_POST, 'id'); if (!is_array($lids) || count($lids) < 1) { echo "<script> alert('Select an item to return'); window.history.go(-1);</script>\n"; exit; } for ($i = 0, $n = count($lids); $i < $n; $i++) { $lend = new mosBookLibrary_lend($database); $lend->load($lids[$i]); $lend->lend_return = date("Y-m-d H:i:s"); if (!$lend->check($lend)) { echo "<script> alert('" . addslashes($lend->getError()) . "'); window.history.go(-1); </script>\n"; exit; } if (!$lend->store()) { echo "<script> alert('" . addslashes($lend->getError()) . "'); window.history.go(-1); </script>\n"; exit; } $lend->checkin(); //$book = new mosBookLibrary($database); //$book->load($lend->fk_bookid); //$book->fk_lendid = 0; $is_update_book_lend = true; if ($is_update_book_lend) { $book = new mosBooklibrary($database); $book->load($id); $query = "SELECT * FROM #__booklibrary_lend WHERE fk_bookid=" . $id . " AND lend_return IS NULL "; $database->setQuery($query); $check_lends = $database->loadObjectList(); if (isset($check_lends[0]->id)) { $book->fk_lendid = $check_lends[0]->id; $is_update_book_lend = false; } else { //$book->load($lend->fk_bookid); $book->fk_lendid = 0; } $book->store(); $book->checkin(); } } mosRedirect("index.php?option={$option}"); }
function getLend() { $lend = null; if ($this->fk_lendid != null && $this->fk_lendid != 0) { $lend = new mosBookLibrary_lend($this->_db); // load the row from the db table $lend->load(intval($this->fk_lendid)); } return $lend; }