public function upgrade($version)
{
$auth = new Auth();
if (!$auth->isLoggedIn() || !$auth->isAdmin()) {
return "Must be logged in as admin";
}
$path = $_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . "library/installer/schemas/update" . $version . ".sql";
if (!file_exists($path)) {
return "Schema does not exist";
}
$settings = WposAdminSettings::getSettingsObject('general');
if (floatval($settings->version) >= floatval($version)) {
return "Db already at the latest version";
}
$sql = file_get_contents($path);
try {
$result = $this->db->_db->exec($sql);
if ($result !== false) {
switch ($version) {
case "1.0":
// set sales type & channel
$sql = "UPDATE `sales` SET `type`='sale', `channel`='pos';";
if ($this->db->_db->exec($sql) === false) {
return $this->db->_db->errorInfo()[0];
}
// set payment dt to process dt and update sales json with extra params
$sql = "SELECT * FROM `sales`;";
$sales = $this->db->select($sql, []);
foreach ($sales as $sale) {
$data = json_decode($sale['data']);
$data->id = $sale['id'];
$data->balance = 0.0;
$data->dt = $sale['dt'];
$data->status = $sale['status'];
if ($data == false) {
die("Prevented null data entry");
}
$sql = "UPDATE `sales` SET `data`=:data WHERE `id`=:saleid";
$this->db->update($sql, [":data" => json_encode($data), ":saleid" => $sale['id']]);
$sql = "UPDATE `sale_payments` SET `processdt=:processdt WHERE `saleid`=:saleid";
$this->db->update($sql, [":processdt" => $sale['processdt'], ":saleid" => $sale['id']]);
}
// update config, add google keys
WposAdminSettings::putValue('general', 'version', '1.0');
WposAdminSettings::putValue('general', 'gcontact', 0);
WposAdminSettings::putValue('general', 'gcontacttoken', '');
WposAdminSettings::putValue('pos', 'priceedit', 'blank');
// copy new templates
copy($_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . 'docs-template/templates', $_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . 'docs/');
break;
case "1.1":
WposAdminSettings::putValue('general', 'version', '1.1');
}
return true;
} else {
return $this->db->_db->errorInfo()[0];
}
} catch (Exception $e) {
return $e->getMessage();
}
}
public function upgrade($version, $authneeded = true)
{
if ($authneeded) {
$auth = new Auth();
if (!$auth->isLoggedIn() || !$auth->isAdmin()) {
return "Must be logged in as admin";
}
}
$path = $_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . "library/installer/schemas/update" . $version . ".sql";
if (!file_exists($path)) {
return "Schema does not exist";
}
$settings = WposAdminSettings::getSettingsObject('general');
if (floatval($settings->version) >= floatval($version)) {
return "Db already at the latest version";
}
$sql = file_get_contents($path);
try {
$result = $this->db->_db->exec($sql);
/*if ($result===false){
echo $this->db->_db->errorInfo()[0];
}*/
switch ($version) {
case "1.0":
// set sales type & channel
$sql = "UPDATE `sales` SET `type`='sale', `channel`='pos';";
if ($this->db->_db->exec($sql) === false) {
return $this->db->_db->errorInfo()[0];
}
// set payment dt to process dt and update sales json with extra params
$sql = "SELECT * FROM `sales`;";
$sales = $this->db->select($sql, []);
foreach ($sales as $sale) {
$data = json_decode($sale['data']);
$data->id = $sale['id'];
$data->balance = 0.0;
$data->dt = $sale['dt'];
$data->status = $sale['status'];
if ($data == false) {
die("Prevented null data entry");
}
$sql = "UPDATE `sales` SET `data`=:data WHERE `id`=:saleid";
$this->db->update($sql, [":data" => json_encode($data), ":saleid" => $sale['id']]);
$sql = "UPDATE `sale_payments` SET `processdt=:processdt WHERE `saleid`=:saleid";
$this->db->update($sql, [":processdt" => $sale['processdt'], ":saleid" => $sale['id']]);
}
// update config, add google keys
WposAdminSettings::putValue('general', 'version', '1.0');
WposAdminSettings::putValue('general', 'gcontact', 0);
WposAdminSettings::putValue('general', 'gcontacttoken', '');
WposAdminSettings::putValue('pos', 'priceedit', 'blank');
// copy new templates
copy($_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . 'docs-template/templates', $_SERVER['DOCUMENT_ROOT'] . $_SERVER['APP_ROOT'] . 'docs/');
break;
case "1.1":
WposAdminSettings::putValue('general', 'version', '1.1');
break;
case "1.2":
// update item tax values
$sql = "SELECT * FROM `sale_items`;";
$items = $this->db->select($sql, []);
foreach ($items as $item) {
if (is_numeric($item['tax'])) {
$taxdata = new stdClass();
$taxdata->values = new stdClass();
$taxdata->inclusive = true;
if ($item['tax'] > 0) {
$taxdata->values->{"1"} = $item['tax'];
$taxdata->total = $item['tax'];
} else {
$taxdata->total = 0;
}
$sql = "UPDATE `sale_items` SET `tax`=:tax WHERE `id`=:id";
$this->db->update($sql, [":tax" => json_encode($taxdata), ":id" => $item['id']]);
} else {
echo "Item record " . $item['id'] . " already updated, skipping item table update...<br/>";
}
}
// remove the "notax taxdata field, update gst to id=1"
$sql = "SELECT * FROM `sales`;";
$sales = $this->db->select($sql, []);
foreach ($sales as $sale) {
$needsupdate = false;
$data = json_decode($sale['data']);
if ($data == false) {
die("Prevented null data entry");
}
if (isset($data->taxdata->{"1"}) && $data->taxdata->{"1"} == 0) {
if (isset($data->taxdata->{"2"})) {
$data->taxdata->{"1"} = $data->taxdata->{"2"};
unset($data->taxdata->{"2"});
} else {
unset($data->taxdata->{"1"});
}
$needsupdate = true;
} else {
echo "Record " . $sale['id'] . " already updated, skipping sale taxdata update...<br/>";
}
foreach ($data->items as $skey => $sitem) {
if (is_numeric($sitem->tax)) {
$taxdata = new stdClass();
$taxdata->values = new stdClass();
$taxdata->inclusive = true;
if ($sitem->tax > 0) {
$taxdata->values->{"1"} = $sitem->tax;
$taxdata->total = $sitem->tax;
} else {
$taxdata->total = 0;
}
$data->items[$skey]->tax = $taxdata;
$needsupdate = true;
} else {
echo "Item record " . $sale['id'] . " already updated, skipping sale itemdata update...<br/>";
}
}
if ($needsupdate) {
$sql = "UPDATE `sales` SET `data`=:data WHERE `id`=:saleid";
$this->db->update($sql, [":data" => json_encode($data), ":saleid" => $sale['id']]);
}
}
// update stored item schema
$sql = "SELECT * FROM `stored_items`;";
$items = $this->db->select($sql, []);
$error = false;
foreach ($items as $item) {
if ($item['data'] == "") {
$id = $item['id'];
unset($item['id']);
$item['type'] = "general";
$item['modifiers'] = new stdClass();
$data = json_encode($item);
if ($data != false) {
$sql = "UPDATE `stored_items` SET `data`=:data WHERE `id`=:id";
if (!$this->db->update($sql, [":data" => $data, ":id" => $id])) {
$error = true;
}
}
}
}
if (!$error) {
$sql = "ALTER TABLE `stored_items` DROP `qty`, DROP `description`, DROP `taxid`;";
$this->db->update($sql, []);
}
// update devices schema
$sql = "SELECT * FROM `devices`;";
$devices = $this->db->select($sql, []);
foreach ($devices as $device) {
if ($device['data'] == "") {
$data = new stdClass();
$data->name = $device['name'];
$data->locationid = $device['locationid'];
$data->type = "general_register";
$data->ordertype = "terminal";
$data->orderdisplay = 1;
$data->kitchenid = 0;
$data = json_encode($data);
if ($data != false) {
$sql = "UPDATE `devices` SET `data`=:data WHERE `id`=:id";
$this->db->update($sql, [":data" => $data, ":id" => $device['id']]);
}
} else {
echo "Device record " . $device['id'] . " already updated, skipping sale itemdata update...<br/>";
}
}
WposAdminSettings::putValue('general', 'currencyformat', '$~2~.~,~0');
WposAdminSettings::putValue('general', 'version', '1.2');
}
// restart node server
$socket = new WposSocketControl();
$socket->restartSocketServer(['error' => 'OK']);
return "Update Completed Successfully!";
} catch (Exception $e) {
echo $this->db->_db->errorInfo()[0];
return $e->getMessage();
}
}
/**
* Set new token set in the config
* @param $token
*/
private static function setNewAccessToken($token)
{
// set new access token in the config
WposAdminSettings::putValue('general', 'gcontacttoken', $token);
}
/**
* Set new token set in the config
* @param $token
*/
private static function setNewToken($token)
{
// add expiry
$token['expiredt'] = time() + 1795;
// -5 seconds for better user experience //TODO: change when partner xero app
// set new access token in the config
WposAdminSettings::putValue('accounting', 'xerotoken', $token);
WposAdminSettings::putValue('accounting', 'xeroenabled', 1);
}