/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('factors', function (Blueprint $table) {
});
$newRow = new Factor();
$newRow->factorname = 'Units';
$newRow->save();
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('factors', function (Blueprint $table) {
//
});
$newFactor = new Factor();
$newFactor->factorname = "High Grades";
$newFactor->save();
$newFactor = new Factor();
$newFactor->factorname = "Unemployment";
$newFactor->save();
$newFactor = new Factor();
$newFactor->factorname = "Overloading";
$newFactor->save();
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('factors', function (Blueprint $table) {
$table->increments('factorid');
$table->string('factorname');
$table->timestamps();
});
//Add rows (factors) to database
$newFactor = new Factor();
$newFactor->factorname = 'Employment';
$newFactor->save();
$newFactor = new Factor();
$newFactor->factorname = 'Grades';
$newFactor->save();
$newFactor = new Factor();
$newFactor->factorname = 'ST Bracket';
$newFactor->save();
$newFactor = new Factor();
$newFactor->factorname = 'Region';
$newFactor->save();
$newFactor = new Factor();
$newFactor->factorname = 'Tuition';
$newFactor->save();
}
public function addquestions($filename)
{
PHPExcel_Settings::setCacheStorageMethod(PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip);
$files = scandir("./upload");
array_shift($files);
array_shift($files);
$errors = array();
$factors = array();
$j = 0;
$this->db->begin();
foreach ($files as $file) {
if (strstr($file, $filename)) {
$objexcel = PHPExcel_IOFactory::load("./upload/" . $file);
$factorsheet = $objexcel->getSheet(0);
$questionsheet = $objexcel->getSheet(1);
$part = new Part();
$part->type = 0;
$part->name = (string) $factorsheet->getCell("B2")->getValue();
$part->description = (string) $factorsheet->getCell("B3")->getValue();
try {
if (!$part->save()) {
$errors[$j]['error'] = "part";
foreach ($part->getMessages() as $key => $message) {
$errors[$j][$key] = $message;
}
$j++;
$this->db->rollback();
$objexcel->disconnectWorksheets();
unlink("./upload/" . $file);
return $errors;
} else {
$higestrow = $factorsheet->getHighestRow();
$i = 5;
while ($i <= $higestrow) {
$factor = new Factor();
$factor->ratio = $factorsheet->getCell("B" . $i)->getValue();
$k = $factorsheet->getCell("A" . $i)->getValue();
if (is_null($k) || $k == "") {
break;
}
if ($factor->save()) {
$factors["{$k}"] = $factor->f_id;
$fprel = new Fprel();
$fprel->factor_id = $factor->f_id;
$fprel->part_id = $part->p_id;
if (!$fprel->save()) {
$errors[$j]['error'] = "fprel";
foreach ($fprel->getMessages() as $key => $message) {
$errors[$j][$key] = $message;
}
$j++;
$this->db->rollback();
$objexcel->disconnectWorksheets();
unlink("./upload/" . $file);
return $errors;
}
} else {
$errors[$j]['error'] = "factor";
foreach ($factor->getMessages() as $key => $message) {
$errors[$j][$key] = $message;
}
$j++;
$this->db->rollback();
$objexcel->disconnectWorksheets();
unlink("./upload/" . $file);
return $errors;
}
$i++;
}
$higestrow = $questionsheet->getHighestRow();
//不可靠
$i = 3;
while ($i <= $higestrow) {
$question = new Question();
$topic = (string) $questionsheet->getCell("A" . $i)->getValue();
if (is_null($topic) || $topic == "") {
break;
}
$question->topic = $topic;
$question->factor_id = $factors[$questionsheet->getCell("C" . $i)->getValue()];
$question->options = "";
$question->grade = "";
$col = "D";
$colnum = $questionsheet->getCell("B" . $i)->getValue();
for ($k = 1; $k <= $colnum; $k++, $col++) {
$str = $questionsheet->getCell($col . $i)->getValue();
$mem = explode("|", $str);
$question->options .= "|" . $mem[0];
$question->grade .= "|" . $mem[1];
}
$question->options = substr($question->options, 1);
$question->grade = substr($question->grade, 1);
if (!$question->save()) {
$errors[$j]['error'] = "question";
$errors[$j]['maxrow'] = $higestrow;
foreach ($question->getMessages() as $key => $message) {
$errors[$j][$key] = $message;
}
$j++;
$this->db->rollback();
$objexcel->disconnectWorksheets();
unlink("./upload/" . $file);
return $errors;
}
$i++;
}
}
} catch (PDOException $ex) {
foreach ($ex->getMessages() as $key => $message) {
$errors[$j][$key] = $message;
}
$j++;
$this->db->rollback();
$objexcel->disconnectWorksheets();
unlink("./upload/" . $file);
throw $ex;
//return $errors;
}
$objexcel->disconnectWorksheets();
unlink("./upload/" . $file);
}
}
$this->db->commit();
return $errors;
}
