}
if ($TrTypeShow == "Transfer") {
$TrTypeShowFormatted = "Tran.";
}
design::table_cell("{$TrStatusShow} - {$TrTypeShowFormatted}", "");
//ACCOUNT
$TrAccountShow = $resultarray[$i]["Account"];
$TrToAccountShow = $resultarray[$i]["ToAccount"];
if ($TrTypeShow == "Transfer") {
design::table_cell("<span data-toggle='tooltip' title='Transfer to: {$TrToAccountShow}' id='tooltip_account_{$lineid}'>{$TrAccountShow}</span>", "");
} else {
design::table_cell($TrAccountShow, "");
}
//PAYEE
$TrPayeeShow = $resultarray[$i]["Payee"];
if (costant::disable_payee() == False) {
design::table_cell($TrPayeeShow, "");
}
//CATEGORY
$TrCategoryShow = $resultarray[$i]["Category"];
$TrSubCategoryShow = $resultarray[$i]["SubCategory"];
if (costant::disable_category() == False && $TrSubCategoryShow != "None") {
design::table_cell("<span data-toggle='tooltip' title='Subcategory: {$TrSubCategoryShow}' id='tooltip_category_{$lineid}'>{$TrCategoryShow}*</span>", "");
} else {
if (costant::disable_category() == False) {
design::table_cell($TrCategoryShow, "");
}
}
//AMOUNT
$TrAmountShow = number_format($resultarray[$i]["Amount"], 2, ",", "");
design::table_cell($TrAmountShow, "text_align_right td_size_5");
if (isset($const_username) and isset($const_password)) {
echo "<h3 class='text_align_center'>Edit settings</h3>";
} else {
echo "<br />";
echo "<p style='text-align:center'><img src='res\\mmex.ico' alt='Money Manager EX Logo' height='150' width='150' /></p>";
echo "<h3 class='text_align_center'>Insert new settings to start use Money Manager</h3>";
}
?>
<br />
<form id="login" method="post" action="settings.php">
<?php
$const_disable_authentication = costant::disable_authentication();
$const_username = costant::login_username();
$const_password = costant::login_password();
$const_desktop_guid = costant::desktop_guid();
$const_disable_payee = costant::disable_payee();
$const_disable_category = costant::disable_category();
$const_defaultaccountname = costant::transaction_default_account();
//SECTION AUTHENTICATION
design::section_legened("Authentication");
if ($const_disable_authentication == True) {
design::settings_checkbox("Set_Disable_authentication", True, "Disable authentication (Not recommended)");
} else {
design::settings_checkbox("Set_Disable_authentication", False, "Disable authentication (Not recommended)");
}
if (isset($const_username) && $const_disable_authentication == False) {
design::settings("Username", $const_username, "", "Text", True);
} else {
design::settings("Username", "", "Insert a new username", "Text", True);
}
if (isset($const_password) && $const_disable_authentication == False) {
$TransactionSubCategory = $resultarray["SubCategory"];
$TransactionAmount = $resultarray["Amount"];
$TransactionNotes = $resultarray["Notes"];
$TransactionSubmit = "Edit transaction";
}
if (sizeof($resultarray) > 0 || $FlagNew == True) {
echo "<div class='container'>";
echo "<form id='Transaction' class='form-transaction' method='post' action = 'insert.php'\r\n onsubmit='return confirm_if_not_present_in_datalist(\"Payee\",\"PayeeList\",\"Do you want to add the new payee\")'>";
echo "<h3 class='text_align_center'>{$TransactionHeaderText}</h3>";
echo "<br />";
design::input_date($TransactionDate);
design::input_status($TransactionStatus);
design::input_type($TransactionType);
design::input_account($TransactionAccount);
design::input_toaccount($TransactionToAccount);
if (costant::disable_payee() !== True) {
design::input_payee($TransactionPayee);
} else {
design::input_hidden("Payee", "None");
}
if (costant::disable_category() !== True) {
design::input_category($TransactionCategory);
design::input_subcategory($TransactionSubCategory);
} else {
design::input_hidden("Category", "None");
design::input_hidden("SubCategory", "None");
}
design::input_amount($TransactionAmount);
design::input_notes($TransactionNotes);
echo "<div class='form-group'>";
echo "<label for='fileToUpload'>Take a picture or upload attachments</label><br />";
public static function to_0_9_9()
{
$parameterarray = array("disable_authentication" => costant::disable_authentication() ? "True" : "False", "user_username" => costant::login_username(), "user_password" => costant::login_password(), "disable_payee" => costant::disable_payee() ? "True" : "False", "disable_category" => "False", "defaultaccountname" => costant::transaction_default_account(), "desktop_guid" => costant::desktop_guid());
various::update_configuration_file($parameterarray);
$const_dbpath = costant::database_path();
$db = new PDO("sqlite:{$const_dbpath}");
$db->exec("ALTER TABLE Payee_List ADD DefCateg TEXT");
$db->exec("ALTER TABLE Payee_List ADD DefSubCateg TEXT");
$db->exec("UPDATE Payee_List SET DefCateg = 'None', DefSubCateg = 'None'");
$db->exec("UPDATE New_Transaction SET Category = 'None', SubCategory = 'None'");
$db->exec("UPDATE Parameters SET Value = '0.9.9' WHERE Parameter = 'Version';");
$db = null;
}
