/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$result = Validator::make(Input::all(), ['title' => 'required', 'author' => 'required', 'publisher' => 'required', 'isbn' => "required|max:13|min:13|regex:/^[1-9][0-9]{12}\$/"], ['title.required' => 'Book title is required', 'author.required' => 'Book author is required', 'isbn.required' => 'ISBN is required', 'isbn.max' => 'ISBN must be exactly 13 characters', 'isbn.min' => 'ISBN must be exactly 13 characters', 'isbn.regex' => 'ISBN must contain numbers only.', 'publisher.required' => 'Publisher is required']);
if ($result->fails()) {
$result->errors()->add('submitted', 1);
$result->errors()->add('desc', Input::get('description') !== "" ? TRUE : FALSE);
return redirect()->route('books.new')->withErrors($result->errors())->withInput();
}
$author_id = $request->get('author_id');
if (intval($author_id) == -1) {
$new_author = new Author();
$new_author->author_name = $request->get('author');
$new_author->save();
$author_id = $new_author->id;
// Create copy of newly created author
$new_author = new Author();
$new_author->author_name = $request->get('author');
$new_author->record_id = $author_id;
$new_author->save();
}
$publisher_id = $request->get('publisher_id');
if (intval($publisher_id) == -1) {
$new_publisher = new Publisher();
$new_publisher->name = $request->get('publisher');
$new_publisher->save();
$publisher_id = $new_publisher->id;
// Create copy of newly created publisher
$new_publisher = new Publisher();
$new_publisher->name = $request->get('publisher');
$new_publisher->record_id = $publisher_id;
$new_publisher->save();
}
$book = new Books();
$book->title = $request->get("title");
$book->author_id = $author_id;
$book->publisher_id = $publisher_id;
$book->isbn = $request->get("isbn");
$book->description = $request->get('description');
$book->date_published = $request->get('date_published');
$book->save();
$book_id = $book->id;
// Create copy of newly created book
$book = new Books();
$book->title = $request->get("title");
$book->author_id = $author_id;
$book->publisher_id = $publisher_id;
$book->isbn = $request->get("isbn");
$book->description = $request->get('description');
$book->date_published = $request->get('date_published');
$book->record_id = $book_id;
$book->save();
return redirect()->route('books.home')->with('status', "New book created");
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
if ($request->get('type') == 'async') {
$validator = Validator::make(Input::all(), ['publisher_name' => 'required|min:5'], ['publisher_name.required' => 'Publisher name is required. Publisher not saved.', 'publisher_name.min' => 'Publisher name must be minimum of 5 characters']);
if ($validator->fails()) {
$return['error'] = $validator->errors();
$return['model'] = ['publisher_name' => FALSE, 'id' => FALSE];
echo json_encode($return);
return;
}
$return['error'] = $validator->errors();
$publisher = new Publisher();
$publisher->name = $request->get('publisher_name');
$publisher->save();
$publisher_id = $publisher->id;
$publisher = new Publisher();
$publisher->name = $request->get('publisher_name');
$publisher->record_id = $publisher_id;
$publisher->save();
$return['model'] = ['publisher_name' => $request->get('publisher_name'), 'id' => $publisher_id];
echo json_encode($return);
return;
}
}
public function getList()
{
$d = [];
// GET LAST THREE YEARS OF DATA
for ($i = 0; $i < 3; $i++) {
$year = date("Y") - $i;
$data = ['dependencia' => '901', "ejercicio" => $year];
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_URL, $this->apiContratos);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data));
$result = curl_exec($ch);
$excercise = json_decode($result);
$d = array_merge($d, $excercise);
}
// SAVE THEM TO THE DB
foreach ($d as $c) {
$contract = Contract::firstOrCreate(['ocdsid' => $c->ocdsID, 'ejercicio' => $c->ejercicio, 'cvedependencia' => $c->cveDependencia, 'nomDependencia' => $c->nomDependencia]);
// save extra data
$meta = $this->getMetaDataX($contract);
if (!empty($meta) && !property_exists($meta, 'error')) {
// add extra data to contracts
$contract->uri = $meta->uri;
$contract->published_date = date("Y-m-d", strtotime($meta->publishedDate));
// create the publisher
$contract->publisher_id = Publisher::firstOrCreate(["scheme" => $meta->publisher->scheme, "name" => $meta->publisher->name, "uri" => $meta->publisher->uri, "uid" => $meta->publisher->uid]);
// update contract
$contract->update();
// create releases
foreach ($meta->releases as $r) {
$release = Release::firstOrCreate(["local_id" => $r->id, "contract_id" => $contract->id, "ocid" => $contract->ocdsid, "date" => date("Y-m-d", strtotime($r->date)), "initiation_type" => $r->initiationType, "language" => $r->language]);
if (count($r->awards)) {
foreach ($r->awards as $aw) {
$award = Award::firstOrCreate(["release_id" => $release->id, "local_id" => $aw->id]);
$award->title = $aw->title;
$award->description = $aw->description;
$award->status = $aw->status;
$award->date = date("Y-m-d", strtotime($aw->date));
$award->value = $aw->value->amount;
$award->currency = $aw->value->currency;
$award->update();
if (count($aw->items)) {
foreach ($aw->items as $it) {
$item = $award->items()->firstOrCreate(['local_id' => $it->id]);
$item->quantity = $it->quantity;
$item->description = $it->description;
$item->unit = $it->unit->name;
$item->update();
}
}
if (count($aw->suppliers)) {
foreach ($aw->suppliers as $sup) {
$supplier = Supplier::firstOrCreate(["award_id" => $aw->id, "rfc" => $sup->identifier->id]);
$supplier->name = $sup->name;
$supplier->street = $sup->address->streetAddress;
$supplier->locality = $sup->address->locality;
$supplier->region = $sup->address->region;
$supplier->zip = $sup->address->postalCode;
$supplier->country = $sup->address->countryName;
$supplier->contact_name = $sup->contactPoint->name;
$supplier->email = $sup->contactPoint->email;
$supplier->phone = $sup->contactPoint->telephone;
$supplier->fax = $sup->contactPoint->faxNumber;
$supplier->url = $sup->contactPoint->url;
$supplier->update();
}
}
}
}
if (count($r->contracts)) {
foreach ($r->contracts as $single) {
$single_contract = SingleContract::firstOrCreate(["local_id" => $single->id, "release_id" => $release->id]);
$single_contract->award_id = $single->awardID;
$single_contract->title = $single->title;
$single_contract->description = $single->description;
$single_contract->status = $single->status;
$single_contract->contract_start = $single->period ? date("Y-m-d", strtotime($single->period->startDate)) : null;
$single_contract->contract_end = $single->period ? date("Y-m-d", strtotime($single->period->endDate)) : null;
$single_contract->amount = $single->value->amount;
$single_contract->currency = $single->value->currency;
$single_contract->date_signed = $single->dateSigned ? date("Y-m-d", strtotime($single->dateSigned)) : null;
$single_contract->documents = count($single->documents);
// ? implode(',',$r->tender->submissionMethod) : null;
$single_contract->update();
if (count($single->items)) {
foreach ($single->items as $it) {
$item = $single_contract->items()->firstOrCreate(['local_id' => $it->id]);
$item->quantity = $it->quantity;
$item->description = $it->description;
$item->unit = $it->unit->name;
$item->update();
}
}
}
}
// create planning
if ($r->planning) {
$planning = Planning::firstOrCreate(["release_id" => $release->id]);
$planning->amount = $r->planning->budget->amount->amount;
$planning->currency = $r->planning->budget->amount->currency;
$planning->project = $r->planning->budget->project;
$planning->update();
//$release->planning_id = $planning->id;
}
// create tender
if ($r->tender) {
$tender = Tender::firstOrCreate(["release_id" => $release->id]);
$tender->local_id = $r->tender->id;
$tender->title = $r->tender->title;
$tender->description = $r->tender->description;
$tender->status = $r->tender->status;
$tender->amount = $r->tender->value ? $r->tender->value->amount : null;
$tender->currency = $r->tender->value ? $r->tender->value->currency : null;
$tender->procurement_method = $r->tender->procurementMethod;
$tender->award_criteria = $r->tender->awardCriteria;
$tender->tender_start = $r->tender->tenderPeriod ? date("Y-m-d", strtotime($r->tender->tenderPeriod->startDate)) : null;
$tender->tender_end = $r->tender->tenderPeriod ? date("Y-m-d", strtotime($r->tender->tenderPeriod->endDate)) : null;
$tender->enquiry_start = $r->tender->enquiryPeriod ? date("Y-m-d", strtotime($r->tender->enquiryPeriod->startDate)) : null;
$tender->enquiry_end = $r->tender->enquiryPeriod ? date("Y-m-d", strtotime($r->tender->enquiryPeriod->endDate)) : null;
$tender->award_start = $r->tender->awardPeriod ? date("Y-m-d", strtotime($r->tender->awardPeriod->startDate)) : null;
$tender->award_end = $r->tender->awardPeriod ? date("Y-m-d", strtotime($r->tender->awardPeriod->endDate)) : null;
$tender->has_enquiries = $r->tender->hasEnquiries;
$tender->eligibility_criteria = $r->tender->eligibilityCriteria;
$tender->submission_method = count($r->tender->submissionMethod) ? implode(',', $r->tender->submissionMethod) : null;
$tender->number_of_tenderers = $r->tender->numberOfTenderers;
$tender->update();
if (count($r->tender->tenderers)) {
foreach ($r->tender->tenderers as $tn) {
$tenderer = Tenderer::firstOrCreate(["rfc" => $tn->identifier->id]);
$tenderer->name = $tn->name;
$tenderer->street = $tn->address->streetAddress;
$tenderer->locality = $tn->address->locality;
$tenderer->region = $tn->address->region;
$tenderer->zip = $tn->address->postalCode;
$tenderer->country = $tn->address->countryName;
$tenderer->contact_name = $tn->contactPoint->name;
$tenderer->email = $tn->contactPoint->email;
$tenderer->phone = $tn->contactPoint->telephone;
$tenderer->fax = $tn->contactPoint->faxNumber;
$tenderer->url = $tn->contactPoint->url;
$tenderer->update();
}
}
if (count($r->tender->items)) {
foreach ($r->tender->items as $it) {
$item = $tender->items()->firstOrCreate(['local_id' => $it->id]);
$item->quantity = $it->quantity;
$item->description = $it->description;
$item->unit = $it->unit->name;
$item->update();
}
}
}
// create buyer
if ($r->buyer) {
$buyer = Buyer::firstOrCreate(["local_id" => $r->buyer->identifier->id, "name" => $r->buyer->name]);
$buyer->uri = $r->buyer->identifier->uri;
$buyer->update();
$release->buyer_id = $buyer->id;
$release->update();
}
}
}
}
echo ":D";
}
public function edit($bookID)
{
if ($this->petugas == null) {
header("Location: " . base . "/Auth");
exit;
}
$book = Book::find($bookID);
$categories = Category::all();
$publishers = Publisher::all();
$this->view->render('admin/add_book', ['categories' => $categories, 'publishers' => $publishers, 'book' => $book, 'petugas' => $this->petugas]);
}
data-success-message="Category %name% successfully created"
class="btn btn-link add-new">
Add new
</button>
</div>
</div>
<div class="form-group">
<label for="publisher" class="col-lg-2 control-label">Publisher</label>
<div class="col-lg-8">
<select id="publisher"
class="selectpicker form-control"
name="publisherId"
data-live-search="true">
<?php
$rows = Publisher::find()->all();
?>
<?php
foreach ($rows as $row) {
?>
<?php
if (!empty($model->bookPublisher)) {
?>
<?php
$selectedRow = $model->bookPublisher->id === $row->id;
?>
<?php
} elseif (!empty($formData['publisher'])) {
?>
<?php
$selectedRow = $row->id == $formData['publisher'][0];
/**
* @return \yii\db\ActiveQuery
*/
public function getBookPublisher()
{
return $this->hasOne(Publisher::className(), ['id' => 'publisherId']);
}
private function savePublisher($contract, $data)
{
// create the publisher
$contract->publisher_id = Publisher::firstOrCreate(["scheme" => $data->publisher->scheme, "name" => $data->publisher->name, "uri" => $data->publisher->uri, "uid" => $data->publisher->uid]);
$contract->update();
return $contract;
}
public function delete($publisherID)
{
Publisher::destroy($publisherID);
header("Location: " . base . "/Publisher");
}
Route::post('/modify-genre', ['as' => 'genre.async.modifyGenre', 'middleware' => 'web', 'uses' => 'GenresController@update']);
Route::post('/list', ['as' => 'genres.async.list', 'middleware' => 'web', 'uses' => 'GenresController@index']);
});
});
Route::group(['prefix' => 'author'], function () {
Route::group(['prefix' => '/async'], function () {
Route::get('/all', ['as' => 'author.async.all', function () {
return \App\Models\Author::where('record_id', NULL)->orderBy('author_name')->get();
}]);
Route::post('/new-author', ['as' => 'author.async.newAuthor', "middleware" => "web", 'uses' => 'AuthorsController@store']);
});
});
Route::group(['prefix' => 'publisher'], function () {
Route::group(['prefix' => '/async'], function () {
Route::get('/all', ['as' => 'publisher.async.all', function () {
return \App\Models\Publisher::where('record_id', NULL)->get();
}]);
Route::post('/new-publisher', ['as' => 'publisher.async.newPublisher', "middleware" => "web", 'uses' => 'PublishersController@store']);
});
});
});
Route::any('/', ["as" => "catalog.index", "uses" => "CatalogController@index"]);
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| This route group applies the "web" middleware group to every route
| it contains. The "web" middleware group is defined in your HTTP
| kernel and includes session state, CSRF protection, and more.
|
