Awaiting Janusz approval to move FrontAccounting Next (Private) to FrontAccounting 2.4.
/Joe
]]>Well done Joe!
Unrelated aside:
Bugfixes 1809-12 pertaining to unstable became marked as access denied in Mantis. Bugfix 1785 is still awaiting inclusion. (Role Elevation from reporter to developer in Mantis has not alleviated the Access denied status for following up on the said Bugs)
]]>Please be aware that when changing date format and/or date separator, that you may need to refresh the page several times to let the js script files, inserts.js and date_picker.js to be copied to /company/X/js_cashe folder where X is the company number.
/Joe
]]>It was reasonaly simple to do, because I initially created the date_picker and the date_functions.
I am just making regorious testing to avoid side-effects, but haven't found any yet. But I am continuing a bit.
After that I will commit it to HG repository.
/Joe
]]>Joe
]]>The date picker does not work at all correctly for this feature choice as of now.
This is only a preliminary delving into the mire that the code currently is.
]]>I am positive to this, just wanting it to mature a bit.
/Joe
]]>http://www.apmuthu.com/bugfixes/fac-dev … format.zip
No way to upload files here!
includes/ui/simple_crud_class.inc has some functions with no change in formatting dates - maybe need to use them - _format_output and _format_input
]]>The html output in FF 15.0.1 for an incorrect display for this format that now shows for one field is:
<input
autocomplete="off"
_last_val="2012-07-13"
name="AfterDate"
class="date"
size="10"
maxlength="12"
value="2012-07-13"
type="text">
<a
tabindex="-1"
href="javascript:date_picker(document.getElementsByName('AfterDate')[0]);">
<img
src="../../themes/default/images/cal.gif"
alt="Click Here to Pick up the date"
border="0"
height="16"
width="16">
</a>Ref Code:
date_cells(_("To:"), 'BeforeDate');
The html output in FF 15.0.1 for a correct initial display field (but not working input function) would be like:
<input
autocomplete="off"
_last_val="12-Aug-2012"
name="BeforeDate"
class="date"
size="10"
maxlength="12"
value="12-Aug-2012"
type="text">
<a
tabindex="-1"
href="javascript:date_picker(document.getElementsByName('BeforeDate')[0]);">
<img
src="../../themes/default/images/cal.gif"
alt="Click Here to Pick up the date"
border="0"
height="16"
width="16">
</a>The initial input size value of 10 may need to become 11 for this format....
The parameters for the functions date_cells and date_row are same and for reference are:
$label,
$name,
$title = null,
$check=null,
$inc_days=0,
$inc_months=0,
$inc_years=0,
$params=null,
$submit_on_change=falseincludes/ui/ui_input.inc (function date_cells)
and
includes/ui/ui_view.inc (function get_js_date_picker)
The insertion places in function get_js_date_picker would be:
At line 842
$monthst = array(_("Jan"),_("Feb"),_("Mar"),_("Apr"),_("May"),_("Jun"),_("Jul"),_("Aug"),_("Sep"),_("Oct"),_("Nov"),_("Dec"));and in the js string at line 922
var monthst = ['$monthst[0]','$monthst[1]','$monthst[2]','$monthst[3]','$monthst[4]','$monthst[5]','$monthst[6]','$monthst[7]','$monthst[8]','$monthst[9]','$monthst[10]','$monthst[11]'];Lines around 1043 can now be altered to:
if ($how == 0)
$js .= "
var dateString = month+'$sep'+day+'$sep'+year;
";
else if ($how == 1)
$js .= "
var dateString = day+'$sep'+month+'$sep'+year;
";
else if ($how == 2)
$js .= "
var dateString = year+'$sep'+month+'$sep'+day;
";
else // ($how == 3)
$js .= "
var dateString = year+'$sep'+monthst[month-1]+'$sep'+day;
";Lines around 1180 can now be altered to:
if ($how == 3)
$js .= "
selectedDay = parseInt(dateParts[0],10);
selectedMonth = monthst.indexOf(dateParts[1])+1;
selectedYear = parseInt(dateParts[2],10);
";
else if ($how == 0)
$js .= "
selectedMonth = parseInt(dateParts[0],10);
selectedDay = parseInt(dateParts[1],10);
selectedYear = parseInt(dateParts[2],10);
";
else if ($how == 1)
$js .= "
selectedDay = parseInt(dateParts[0],10);
selectedMonth = parseInt(dateParts[1],10);
selectedYear = parseInt(dateParts[2],10);
";
else
$js .= "
selectedYear = parseInt(dateParts[0],10);
selectedMonth = parseInt(dateParts[1],10);
selectedDay = parseInt(dateParts[2],10);
";It still does not work fully........
]]>File: config.php / config.default.php
Replace Line 139:
$dateformats = array("MMDDYYYY", "DDMMYYYY", "YYYYMMDD");
With:
$dateformats = array("MMDDYYYY", "DDMMYYYY", "YYYYMMDD", "DDMmmYYYY");
Correct "defalt" to "default" in commented line 143.
File: includes/date_functions.inc
1.
Replace lines 38-39:
else
return $year.$sep.$month.$sep.$day;
With:
elseif ($how == 2)
return $year.$sep.$month.$sep.$day;
else
return $day.$sep.date('M', $year.$month.$day).$sep.$year;
2. Altered fragment in function is_date($date_)
elseif (strlen($date_) == 8)
{
if ($how == 3) // So as not to affect Jalali processing
{
$day = substr($date_,0,1);
$month = date('m', strtotime(substr($date_,1,3)));
$year = substr($date_,4,4);
}
elseif ($how == 0)
{
$day = substr($date_,2,2);
$month = substr($date_,0,2);
$year = substr($date_,4,4);
}
elseif ($how == 1)
{
$day = substr($date_,0,2);
$month = substr($date_,2,2);
$year = substr($date_,4,4);
}
else
{
$day = substr($date_,6,2);
$month = substr($date_,4,2);
$year = substr($date_,0,4);
}
}
elseif (strlen($date_) == 9)
{
if ($how == 3)
{
$day = substr($date_,0,2);
$month = date('m', strtotime(substr($date_,2,3)));
$year = substr($date_,5,4);
}
else
return 0;
}3. Altered fragment in function sql2date[$date_)
// Split up the date by the separator based on "how" to split it
if ($how == 0) // MMDDYYYY
list($month, $day, $year) = explode($sep, $date_);
elseif ($how == 1) // DDMMYYYY
list($day, $month, $year) = explode($sep, $date_);
elseif ($how == 2) // YYYYMMDD
list($year, $month, $day) = explode($sep, $date_);
elseif ($how == 3) // DDMmmYYYY
list($year, $month, $day) = explode($sep, date('Y-m-d', strtotime($date_)));
else
return "";Will work on this feature when time permits as it needs a complete implementation. This is the preferred date format in ASEAN countries what with the EU/US confusion on the date score...especially for CPAs who need to cater to clients across the globe and have "unambiguous" reports.
We need to cull out all instances of
1. Date Display
2. Date Form Fields
3. Date Picker (through wrapper function)
4. Date Picker (any unwrapped)
5. Date field computation
6. Date in SQL unabstracted
Any inputs here will help make for a smooth integration without catastrophic suprises.
]]>