/**
* @test
*/
public function get_current_cost_for_material()
{
$material = Material::find(13);
$this->assertInstanceOf(Material::class, $material);
$cost_logs_last = $material->costLogs->sortByDesc('mat_cost_date')->first()->mat_cost_cost_kg;
$cost = $material->current_cost->mat_cost_cost_kg;
$this->assertEquals($cost_logs_last, $cost, "Current Cost");
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Material::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
/**
* @test
*/
public function material_edit_complete_form_submit_correct()
{
$this->visit('/material/13/edit')->see('MTech MIS Login Screen');
$user = User::find(46);
$this->actingAs($user)->visit('/material/13/edit')->type("cOPP20", 'material_description')->type("Clear BOPP20", 'material_fronthouse_name')->type("20", 'material_micron')->select("8", 'material_supplier_id_fk')->select("7", 'material_grade_id_fk')->select("KG", 'material_uom')->type("14", 'material_lead_time')->select("1", 'material_buy')->type("Test notes", 'material_notes')->press("Save")->assertSessionHas('flash');
$this->assertResponseOk();
$material = Material::find(13);
$this->assertEquals('cOPP20', $material->material_description);
$this->assertEquals('Clear BOPP20', $material->material_fronthouse_name);
$this->assertEquals('20', $material->material_micron);
$this->assertEquals('8', $material->material_supplier_id_fk);
$this->assertEquals('7', $material->material_grade_id_fk);
$this->assertEquals('KG', $material->material_uom);
$this->assertEquals('14', $material->material_lead_time);
$this->assertEquals('1', $material->material_buy);
$this->assertEquals('Test notes', $material->material_notes);
}
public function deliveryOrder($returpener_id)
{
$get = DoReturpener::where('returpener_id', $returpener_id);
if ($get->count() == 0) {
if (DoReturpener::count() == 0) {
$numb = '001/JIU/' . romawi()[date('n')] . '/' . date('Y');
} else {
$last = DoReturpener::orderBy('dorp_id', 'DESC')->take(1)->pluck('dorp_no');
$path = explode('/', $last);
$preffix = '';
$path[0]++;
for ($x = 0; $x < 3 - strlen($path[0]); $x++) {
$preffix .= '0';
}
$numb = $preffix . $path[0] . '/JIU/' . romawi()[date('n')] . '/' . date('Y');
}
DoReturpener::create(['returpener_id' => $returpener_id, 'dorp_no' => $numb]);
} else {
$row = $get->first();
$numb = $row->dorp_no;
}
#Update status to 'DO has been created'
$get = Returpener::find($returpener_id);
$get->returpener_status = 6;
$get->save();
#End
#Reduce material's stock
$mats = Returpeners::getMatData($returpener_id);
foreach ($mats as $mat) {
if ($mat->returpeners_is_reduced == 2) {
#Reducing stock...
$eachMat = Material::find($mat->mat_id);
$eachMat->mat_stock_akhir = $eachMat->mat_stock_akhir - $mat->returpeners_jml;
$eachMat->save();
#End
#Update is_reduced field
$each = Returpeners::find($mat->returpeners_id);
$each->returpeners_is_reduced = 1;
$each->save();
#End
}
}
#End
$data = ['asset' => new Assets(), 'title' => 'Print Retur Delivery Order', 'head' => Returpener::fetchHead($returpener_id), 'sub' => Returpeners::fetch($returpener_id), 'numb' => $numb];
return view('printing.do', $data);
}
public function acceptanceStore(Request $req)
{
$vals = ['po_id' => $_POST['po_id'], 'pener_date' => now(), 'userid_input' => Auth::user()->user_id, 'visibility' => 1];
$pener = Pener::create($vals);
foreach ($_POST['pos_id'] as $pos_id) {
if (!empty($_POST['peners_jml_' . $pos_id])) {
$vals = ['pener_id' => $pener->pener_id, 'pos_id' => $pos_id, 'peners_jml' => $_POST['peners_jml_' . $pos_id]];
Peners::create($vals);
if (!empty($_POST['mat_id_' . $pos_id])) {
$mat = MatModel::find($_POST['mat_id_' . $pos_id]);
$mat->mat_stock_akhir = $mat->mat_stock_akhir + $_POST['peners_jml_' . $pos_id];
$mat->save();
}
}
}
#Checking for update po_status
$sub = Po_sub::fetchDetail($_POST['po_id']);
$el = array();
foreach ($sub as $row) {
$diterima = countDiterima($row->pos_id);
$rest = $row->pbs_jml - $diterima;
if ($rest > 0) {
array_push($el, 'open');
}
}
if (!in_array('open', $el)) {
$rec = Po::find($_POST['po_id']);
$rec->po_status = 2;
$rec->save();
}
#End of checking
Session::flash('inserted', '<div class="info success">Penerimaan material berhasil diinput.</div>');
return redirect('material/acceptance');
}
/**
* Update the specified resource in storage.
*
* @param Request $status
* @param int $id
* @return Response
*/
public function updateFiltered($id, Request $request)
{
if ($request->status == "approved") {
$material = Material::find($id);
$material->filtered = true;
$material->save();
} else {
Material::destroy($id);
}
}
/**
* update.
*
* @param int $id
* @param array $input
*/
public function update($id, $input)
{
$model = $this->model->find($id);
return $this->fillSavePost($model, $input);
}
public function closingStockDo(Request $req)
{
$cs = Cs::create(['user_id' => $this->_user->user_id, 'cs_year' => $req->input('year')]);
foreach (MatModel::fetchForClosing() as $row) {
$vals = ['cs_id' => $cs->cs_id, 'mat_id' => $row->mat_id, 'mat_stock_awal' => $row->mat_stock_awal, 'mat_stock_akhir' => $row->mat_stock_akhir];
Csm::create($vals);
$mat = MatModel::find($row->mat_id);
$mat->mat_stock_awal = $mat->mat_stock_akhir;
$mat->save();
}
Session::flash('success', '<div class="info success">Closing Stok untuk tahun ' . $req->input('year') . ' berhasil dilakukan.</div>');
return redirect('material/closingStock');
}
