public function measurements()
{
////////////////MEASUREMENT HEAD////////////////
$ids = DB::table('tblMeasurementHeader')->select('strMeasurementID')->orderBy('created_at', 'desc')->orderBy('strMeasurementID', 'desc')->take(1)->get();
$ID = $ids["0"]->strMeasurementID;
$categoryNewID = $this->smartCounter($ID);
$records = MeasurementHead::all();
$array = array();
foreach ($records as $record) {
if (count($array) == 0) {
$item1 = array();
$item1[0] = $record->strCategoryName;
$item1[1] = $record->strSegmentName;
$item1[2] = [$record->strMeasurementName];
array_push($array, $item1);
continue;
}
$doesExist = FALSE;
foreach ($array as $checker) {
if ($checker[0] == $record->strCategoryName && $checker[1] == $record->strSegmentName) {
$doesExist = TRUE;
break;
}
}
if (!$doesExist) {
$itemPush = array();
$itemPush[0] = $record->strCategoryName;
$itemPush[1] = $record->strSegmentName;
$itemPush[2] = [$record->strMeasurementName];
array_push($array, $itemPush);
continue;
}
for ($i = 0; $i < count($array); $i++) {
if ($array[$i][0] == $record->strCategoryName && $array[$i][1] == $record->strSegmentName) {
array_push($array[$i][2], $record->strMeasurementName);
}
}
}
$head = DB::table('tblMeasurementHeader AS a')->leftJoin('tblGarmentCategory AS b', 'a.strCategoryName', '=', 'b.strGarmentCategoryID')->leftJoin('tblGarmentSegment AS c', 'a.strSegmentName', '=', 'c.strGarmentSegmentID')->leftJoin('tblMeasurementDetail AS d', 'a.strMeasurementName', '=', 'd.strMeasurementDetailID')->leftJoin('tblReasonMeasurementCategory AS e', 'a.strMeasurementID', '=', 'e.strInactiveHeadID')->select('a.*', 'b.strGarmentCategoryName', 'c.strGarmentSegmentName', 'd.strMeasurementDetailName', 'e.strInactiveHeadID', 'e.strInactiveReason')->orderBy('created_at')->get();
$category = Category::all();
$segment = Segment::all();
$detailList = MeasurementDetail::all();
$reasonHead = ReasonMeasurementCategory::all();
////////////////MEASUREMENT HEAD////////////////
////////////////MEASUREMENT DETAILS////////////////
$ids = DB::table('tblMeasurementDetail')->select('strMeasurementDetailID')->orderBy('created_at', 'desc')->orderBy('strMeasurementDetailID', 'desc')->take(1)->get();
$ID = $ids["0"]->strMeasurementDetailID;
$detailNewID = $this->smartCounter($ID);
$detail = MeasurementDetail::all();
$reasonDetail = ReasonMeasurementDetail::all();
$detail = DB::table('tblMeasurementDetail')->leftJoin('tblReasonMeasurementDetail', 'tblMeasurementDetail.strMeasurementDetailID', '=', 'tblReasonMeasurementDetail.strInactiveDetailID')->select('tblMeasurementDetail.*', 'tblReasonMeasurementDetail.strInactiveDetailID', 'tblReasonMeasurementDetail.strInactiveReason')->orderBy('created_at')->get();
////////////////MEASUREMENT DETAILS////////////////
// dito magbabago
return View::make('measurements')->with('head', $head)->with('detail', $detail)->with('reasonDetail', $reasonDetail)->with('reasonHead', $reasonHead)->with('categoryNewID', $categoryNewID)->with('detailNewID', $detailNewID)->with('category', $category)->with('segment', $segment)->with('detailList', $detailList);
}
public function pattern()
{
$ids = DB::table('tblDesignPattern')->select('strDesignPatternID')->orderBy('created_at', 'desc')->orderBy('strDesignPatternID', 'desc')->take(1)->get();
$ID = $ids["0"]->strDesignPatternID;
$newID = $this->smartCounter($ID);
$category = Category::all();
$segment = Segment::all();
$reason = ReasonDesignPattern::all();
$pattern = DB::table('tblDesignPattern')->join('tblGarmentCategory', 'tblDesignPattern.strDesignCategory', '=', 'tblGarmentCategory.strGarmentCategoryID')->join('tblGarmentSegment', 'tblDesignPattern.strDesignSegmentName', '=', 'tblGarmentSegment.strGarmentSegmentID')->leftJoin('tblReasonDesignPattern', 'tblDesignPattern.strDesignPatternID', '=', 'tblReasonDesignPattern.strInactivePatternID')->select('tblDesignPattern.*', 'tblGarmentCategory.strGarmentCategoryName', 'tblGarmentSegment.strGarmentSegmentName', 'tblReasonDesignPattern.strInactivePatternID', 'tblReasonDesignPattern.strInactiveReason')->orderBy('strDesignPatternID')->get();
return View::make('designPattern')->with('newID', $newID)->with('pattern', $pattern)->with('category', $category)->with('reason', $reason)->with('segment', $segment);
}
public function editGarmentSegment()
{
$id = Input::get('editSegmentID');
$segment = Segment::find($id);
$segs = Segment::all();
$isAdded = FALSE;
$validInput = TRUE;
$regex = "/^[a-zA-Z\\'\\-]+( [a-zA-Z\\'\\-]+)*\$/";
$regexDesc = "/^[a-zA-Z0-9\\'\\-\\.\\,]+( [a-zA-Z0-9\\,\\'\\-\\.]+)*\$/";
if (!trim(Input::get('editSegmentName')) == '' || !trim(Input::get('editSegmentDesc')) == '') {
$validInput = TRUE;
if (preg_match($regex, Input::get('editSegmentName')) && preg_match($regexDesc, Input::get('editSegmentDesc'))) {
$validInput = TRUE;
} else {
$validInput = FALSE;
}
} else {
$validInput = FALSE;
}
foreach ($segs as $seg) {
if (!strcasecmp($seg->strGarmentSegmentID, Input::get('editSegmentID')) == 0 && strcasecmp($seg->strGarmentSegmentName, trim(Input::get('editSegmentName'))) == 0 && strcasecmp($seg->strCategory, Input::get('editCategory')) == 0) {
$isAdded = TRUE;
}
}
if ($validInput) {
if (!$isAdded) {
$segment->strCategory = Input::get('editCategory');
$segment->strGarmentSegmentName = trim(Input::get('editSegmentName'));
$segment->strGarmentSegmentDesc = trim(Input::get('editSegmentDesc'));
$segment->save();
return Redirect::to('/maintenance/garmentsDetails?successEdit=true');
} else {
return Redirect::to('/maintenance/garmentsDetails?success=duplicate');
}
} else {
return Redirect::to('/maintenance/garmentsDetails?input=invalid');
}
}
