function convertArray($arr)
{
$newArr = [];
foreach ($arr as $key => $value) {
$newKey = convertFromTitleCaseToSlug($key);
if (is_array($value)) {
$newArr += [$newKey => convertArray($value)];
} else {
$newArr += [$newKey => $value];
}
}
return $newArr;
}
function addRecord($iodizationCentre)
{
$s = microtime(true);
/*mark the timestamp at the beginning of the transaction*/
if ($this->input->post()) {
//check if a post was made
if ($_POST['brandname']) {
$_POST['brandname'] = convertArray($_POST['brandname']);
}
if ($_POST['brandname2']) {
$_POST['brandname2'] = convertArray($_POST['brandname2']);
}
unset($_POST['item_id']);
$this->elements = array();
$this->theIds = array();
foreach ($this->input->post() as $key => $val) {
//For every posted values
//print(($key." ".$val)).'<br \>';
//check if posted value is among the cloned ones
if (!strpos("_", $key)) {
//useful to keep all the non-cloned elements in the loop
$key = $key . "_1";
}
//we separate the attribute name from the number
$this->frags = explode("_", $key);
$this->id = $this->frags[1];
// the id
$this->attr = $this->frags[0];
//the attribute name
$this->theIds[$this->attr] = $this->id;
//print($this->attr." ".$this->id." ".$val).'<br />';
if (!empty($val)) {
//We then store the value of this attribute for this element.
$this->elements[$this->id][$this->attr] = htmlentities($val);
}
}
//close foreach($_POST)
//print_r($this->elements);
//die();
//exit;
//get the highest value of the array that will control the number of inserts to be done
$this->noOfInsertsBatch = max($this->theIds);
//iodization centre name obtained from the session variable => 'affiliation'
for ($i = 1; $i <= $this->noOfInsertsBatch; ++$i) {
$this->theForm = new \models\Entities\entities_maize\e_maize_production();
//create an object of the model/*
$this->theForm->setcompany_name($this->elements[$i]["maizeFactory1"]);
$this->theForm->setyear($this->elements[$i]["harvestYear"]);
$this->theForm->setprod_month($this->elements[$i]["prodMonth"]);
$this->theForm->setopening_balance(isset($this->elements[$i]["oBal"]) ? $this->elements[$i]["oBal"] : 0);
$this->theForm->setqty_delivered(isset($this->elements[$i]["qtyDel"]) ? $this->elements[$i]["qtyDel"] : 0);
$this->theForm->setsupplier(isset($this->elements[$i]["pSup"]) ? $this->elements[$i]["pSup"] : 'N/A');
$this->theForm->setqty_rejected(isset($this->elements[$i]["reject"]) ? $this->elements[$i]["reject"] : 0);
$this->theForm->setqty_issued(isset($this->elements[$i]["QI"]) ? $this->elements[$i]["QI"] : 0);
$this->theForm->setsales(isset($this->elements[$i]["sales"]) ? $this->elements[$i]["sales"] : 0);
$this->theForm->setclosing_balance(isset($this->elements[$i]["CBAL"]) ? $this->elements[$i]["CBAL"] : 0);
$this->theForm->setdosage_rate(isset($this->elements[$i]["DRM"]) ? $this->elements[$i]["DRM"] : 0);
$this->theForm->settheoretical_prod(isset($this->elements[$i]["tProdM"]) ? $this->elements[$i]["tProdM"] : 0);
$this->theForm->setactual_prod(isset($this->elements[$i]["aProd"]) ? $this->elements[$i]["aProd"] : 0);
$this->theForm->setproduction_unfort(isset($this->elements[$i]["prodU"]) ? $this->elements[$i]["prodU"] : 0);
$this->theForm->setexp_fort(isset($this->elements[$i]["fortExp"]) ? $this->elements[$i]["fortExp"] : 0);
$this->theForm->setexp_unfort(isset($this->elements[$i]["salexExpUn"]) ? $this->elements[$i]["salexExpUn"] : 0);
$this->theForm->setfort_brands(isset($this->elements[$i]["brandname"]) ? $this->elements[$i]["brandname"] : "N/A");
$this->theForm->setunfort_brands(isset($this->elements[$i]["brandname2"]) ? $this->elements[$i]["brandname2"] : "N/A");
$this->theForm->setsignature($this->session->userdata('email'));
$this->theForm->settime_added("" . date('Y-m-d'));
$this->theForm->setedited_by("N/A");
$this->theForm->settime_edited("0000-00-00");
// print_r($this -> theForm);
$this->em->persist($this->theForm);
//echo "here";
//die();
//now do a batched insert, default at 5
$this->batchSize = 5;
if ($i % $this->batchSize == 0) {
try {
$this->em->flush();
$this->em->clear();
//detactes all objects from doctrine
} catch (Exception $ex) {
die($ex->getMessage());
/*display user friendly message*/
}
//end of catch
} else {
if ($i < $this->batchSize || $i > $this->batchSize || $i == $this->noOfInsertsBatch && $this->noOfInsertsBatch - $i < $this->batchSize) {
//total records less than a batch, insert all of them
try {
$this->em->flush();
$this->em->clear();
//detactes all objects from doctrine
} catch (Exception $ex) {
die($ex->getMessage());
/*display user friendly message*/
}
//end of catch
}
}
//end of batch condition
}
//end of innner loop
}
//close the this->input->post
$e = microtime(true);
$this->executionTime = round($e - $s, '4');
$this->rowsInserted = $this->noOfInsertsBatch;
return $this->response = 'ok';
}
function convertArray($ar)
{
$var = '{ ';
foreach ($ar as $key => $val) {
$var .= '"' . $key . '" : ';
if (is_array($val)) {
$var .= convertArray($val) . ', ';
} else {
$var .= '"' . $val . '", ';
}
}
if ($var[strlen($var) - 2] == ',') {
$var[strlen($var) - 2] = ' ';
}
return $var . '} ';
}
function convertArray($array, $inCharset, $outCharset)
{
if (!is_array($array)) {
showError("convertArray: not an array was passed");
var_dump($array);
return;
}
foreach (array_keys($array) as $key) {
$value = $array[$key];
if (is_string($value)) {
// First check if $inCharset is correct
$valueTest = iconv($inCharset, $inCharset, $value);
if (strlen($valueTest) != strlen($value)) {
if (CommandLineArguments::logFilename() !== false) {
$logString = "ERROR: Unable to predict correct character set while converting array. Value is {$value}, inCharset : {$inCharset}, outCharset : {$outCharset}\n";
file_put_contents(CommandLineArguments::logFilename(), $logString, FILE_APPEND);
}
}
$array[$key] = iconv($inCharset, $outCharset . '//TRANSLIT', $value);
} else {
if (is_array($value)) {
$array[$key] = convertArray($value, $inCharset, $outCharset);
} else {
//nothing to do
}
}
}
return $array;
}
function proceedToAccount()
{
$val = $this->input->get_post('selectedvehicle');
$c_id = convertArray($val);
$filter = array('vehicle_company_id' => $c_id);
$aff = $this->v->get_details($filter);
foreach ($aff as $rw) {
$veh_id = $rw->vehicle_id;
}
$aff = $this->f->get_vehicleName($veh_id);
$setdta = array('affiliation' => $aff, 'vehicle' => $aff);
//print_r($setdta);
//die();
$this->session->set_userdata($setdta);
redirect(base_url() . 'c_front/vehicles', 'refresh');
}
