/* $Id: tbl_change.js,v 1.2 2006/03/21 15:06:27 web Exp $ */


/**
 * Modify from controls when the "NULL" checkbox is selected
 *
 * @param   string   the MySQL field type
 * @param   string   the urlencoded field name
 * @param   string   the md5 hashed field name
 *
 * @return  boolean  always true
 */

var month_names = new Array("Янв","Фев","Мар","Апр","Май","Июн","Июл","Авг","Сен","Окт","Ноя","Дек");
var day_names = new Array("Пн","Вт","Ср","Чт","Пт","Сб","Вс");

function nullify(theType, urlField, md5Field, multi_edit)
{
    var rowForm = document.forms['insertForm'];

    if (typeof(rowForm.elements['funcs' + multi_edit + '[' + urlField + ']']) != 'undefined') {
        rowForm.elements['funcs' + multi_edit + '[' + urlField + ']'].selectedIndex = -1;
    }

    // "SET" field , "ENUM" field with more than 20 characters
    // or foreign key field
    if (theType == 1 || theType == 3 || theType == 4) {
        rowForm.elements['field_' + md5Field + multi_edit + '[]'].selectedIndex = -1;
    }
    // Other "ENUM" field
    else if (theType == 2) {
        var elts     = rowForm.elements['field_' + md5Field + multi_edit + '[]'];
        // when there is just one option in ENUM:
        if (elts.checked) {
            elts.checked = false;
        } else {
            var elts_cnt = elts.length;
            for (var i = 0; i < elts_cnt; i++ ) {
                elts[i].checked = false;
            } // end for

        } // end if
    }
    // Other field types
    else /*if (theType == 5)*/ {
        rowForm.elements['fields' + multi_edit + '[' + urlField + ']'].value = '';
    } // end if... else if... else

    return true;
} // end of the 'nullify()' function


/**
 * Unchecks the "NULL" control when a function has been selected or a value
 * entered
 *
 * @param   string   the urlencoded field name
 *
 * @return  boolean  always true
 */
function unNullify(urlField, multi_edit)
{
    var rowForm = document.forms['insertForm'];

    if (typeof(rowForm.elements['fields_null[multi_edit][' + multi_edit + '][' + urlField + ']']) != 'undefined') {
        rowForm.elements['fields_null[multi_edit][' + multi_edit + '][' + urlField + ']'].checked = false
    } // end if

    if (typeof(rowForm.elements['insert_ignore_' + multi_edit]) != 'undefined') {
        rowForm.elements['insert_ignore_' + multi_edit].checked = false
    } // end if

    return true;
} // end of the 'unNullify()' function

var day;
var month;
var year;
var hour;
var minute;
var second;
var clock_set = 0;

/**
 * Opens calendar window.
 *
 * @param   string      calendar.php parameters
 * @param   string      form name
 * @param   string      field name
 * @param   string      edit type - date/timestamp
 */

function close_cal() {
  // закрываем другие календари
   if ( document.getElementById('div_calendar1') )document.getElementById('div_calendar1').style.display = 'none';
   if ( document.getElementById('div_calendar2') )document.getElementById('div_calendar2').style.display = 'none';
   if ( document.getElementById('div_calendar') )document.getElementById('div_calendar').style.display = 'none';
}

// последний параметр значит что этот кледарь на форме регистрации, у него свой интервал годов. - это костыли
// потом переделать на задание производного интервала.
function openCalendar(form, field, type,num_cal,reg) {
  close_cal();
  num_cal = ( num_cal ) ? num_cal : '';
	if ( type == "date" ) height = 176;
	else height = 220;
	//alert('div_calendar'+num_cal+'');
  //document.getElementById('div_calendar'+num_cal+'').style.top = event.pageX +"px";  
	document.getElementById('div_calendar'+num_cal+'').style.display = '';
    dateField = eval("document." + form + "." + field);
    dateType = type;
    initCalendar(num_cal,reg);
    
}

/**
 * Formats number to two digits.
 *
 * @param   int number to format.
 */
function formatNum2(i, valtype) {
    f = (i < 10 ? '0' : '') + i;
    if (valtype && valtype != '') {
        switch(valtype) {
            case 'month':
                f = (f > 12 ? 12 : f);
                break;

            case 'day':
                f = (f > 31 ? 31 : f);
                break;

            case 'hour':
                f = (f > 24 ? 24 : f);
                break;

            default:
            case 'second':
            case 'minute':
                f = (f > 59 ? 59 : f);
                break;
        }
    }

    return f;
}

/**
 * Formats number to four digits.
 *
 * @param   int number to format.
 */
function formatNum4(i) {
    return (i < 1000 ? i < 100 ? i < 10 ? '000' : '00' : '0' : '') + i;
}

/**
 * Initializes calendar window.
 */
function initCalendar(num_cal,reg) {
    if (!year && !month && !day) {
        /* Called for first time */
        if (dateField.value) {
            value = dateField.value;
            if (dateType == 'datetime' || dateType == 'date') {
                if (dateType == 'datetime') {
                    parts   = value.split(' ');
                    value   = parts[0];

                    if (parts[1]) {
                        time    = parts[1].split(':');
                        hour    = parseInt(time[0],10);
                        minute  = parseInt(time[1],10);
                        second  = parseInt(time[2],10);
                    }
                }
                date        = value.split("-");
                day         = parseInt(date[2],10);
                month       = parseInt(date[1],10) - 1;
                year        = parseInt(date[0],10);
            } else {
                year        = parseInt(value.substr(0,4),10);
                month       = parseInt(value.substr(4,2),10) - 1;
                day         = parseInt(value.substr(6,2),10);
                hour        = parseInt(value.substr(8,2),10);
                minute      = parseInt(value.substr(10,2),10);
                second      = parseInt(value.substr(12,2),10);
            }
        }
        if (isNaN(year) || isNaN(month) || isNaN(day) || day == 0) {
            dt      = new Date();
            year    = dt.getFullYear();
            month   = dt.getMonth();
            day     = dt.getDate();
        }
        if (isNaN(hour) || isNaN(minute) || isNaN(second)) {
            dt      = new Date();
            hour    = dt.getHours();
            minute  = dt.getMinutes();
            second  = dt.getSeconds();
        }
    } else {
        /* Moving in calendar */
        if (month > 11) {
            month = 0;
            year++;
        }
        if (month < 0) {
            month = 11;
            year--;
        }
    }

    if (document.getElementById) {
        cnt = document.getElementById("calendar_data"+num_cal+"");
    } else if (document.all) {
        cnt = document.all["calendar_data"+num_cal+""];
    }

    cnt.innerHTML = "";

    str = ""

    //heading table
    str += '<div class="cal-main"><table cellpadding="0" cellspacing="0" border="0" width="100%"><tr><td align="right" style="padding:6px 17px 0 0;"><img src="/i/cal-close.gif" width="10" height="10" alt="закрыть" style="cursor:hand;" onclick="document.getElementById(\'div_calendar'+num_cal+'\').style.display = \'none\';"></td></tr><tr>';
    str += '<td style="padding:2px 0 6px 30px;"><a href="javascript:month--; initCalendar('+num_cal+','+reg+');" style="font-size:18px;"><b>&laquo;</b></a>';
    str += '<select id="select_month" name="monthsel" onchange="month = parseInt(document.getElementById(\'select_month\').value); initCalendar('+num_cal+','+reg+');">';
    for (i =0; i < 12; i++) {
        if (i == month) selected = ' selected="selected"';
        else selected = '';
        str += '<option value="' + i + '" ' + selected + '>' + month_names[i] + '</option>';
    }
    str += '</select>';
    str += ' <a href="javascript:month++; initCalendar('+num_cal+','+reg+');" style="font-size:18px;"><b>&raquo;</b></a>';
    str += '<img src="/i/0.gif" width="30" height="1" alt="">';
    str += '<a href="javascript:year--; initCalendar('+num_cal+','+reg+');" style="font-size:18px;"><b>&laquo;</b></a> ';
    str += '<select id="select_year" name="yearsel" onchange="year = parseInt(document.getElementById(\'select_year\').value); initCalendar('+num_cal+','+reg+');">';
	
	if ( reg ) {
		end_year = 2010; start_year = 1950;
	} else {
		end_year = year + 1; start_year = year - 10;
	}
	
    for (i = start_year; i < end_year; i++) {
        if (i == year) selected = ' selected="selected"';
        else selected = '';
        str += '<option value="' + i + '" ' + selected + '>' + i + '</option>';
    }
    str += '</select>';
    str += ' <a href="javascript:year++; initCalendar('+num_cal+','+reg+');" style="font-size:18px;"><b>&raquo;</b></a>';

    str += '</td></tr><tr><td style="padding:0 8px 0 1px;"><table cellpadding="0" cellspacing="0" border="0" width="100%"><tr id="cal-work"><td width="41">&nbsp;</td>';
    // дни недели
    for (i = 0; i < 7; i++) {
        str += "<td>" + day_names[i] + "</td>";
    }
    str += "<td width=\"37\">&nbsp;</td></tr>";
    var firstDay = new Date(year, month, 0).getDay();
    var lastDay = new Date(year, month + 1, 0).getDate();

    str += '<tr style="height:23px;" id="cal-day"><td width="41">&nbsp;</td>';

    dayInWeek = 0;
    // пустой день
    for (i = 0; i < firstDay; i++) {
        str += "<td>&nbsp;</td>";
        dayInWeek++;
    }
    
    for (i = 1; i <= lastDay; i++) {
        if (dayInWeek == 7) {
            str += '</tr><tr id="cal-day"><td width="41">&nbsp;</td>';
            dayInWeek = 0;
        }

        dispmonth = 1 + month;

        if (dateType == 'datetime' || dateType == 'date') {
            actVal = formatNum4(year) + "-" + formatNum2(dispmonth, 'month') + "-" + formatNum2(i, 'day');
        } else {
            actVal = "" + formatNum4(year) + formatNum2(dispmonth, 'month') + formatNum2(i, 'day');
        }
        acolor = "";
        
        if (i == day) {
            style = ' id="cal-daysel"';
            acolor = "style=\"color:#fff\"";
        } else {
            style = '';
        }
        str += "<td" + style + " onmouseover=\"this.style.backgroundColor='#e3e7ee';\" onmouseout=\"this.style.backgroundColor='';\"><a "+acolor+" href=\"javascript:returnDate('" + actVal + "');\">" + i + "</a></td>"
        dayInWeek++;
    }
    for (i = dayInWeek; i < 7; i++) {
        str += "<td>&nbsp;</td>";
    }

    str += "<td width=\"37\">&nbsp;</td></tr></table></td></tr></table></div>";

    cnt.innerHTML = str;


    // Should we handle time also?
    if (dateType != 'date' && !clock_set) {

        if (document.getElementById) {
            cnt = document.getElementById("clock_data");
        } else if (document.all) {
            cnt = document.all["clock_data"];
        }

        str = '<div class="time">';
        str += '<form class="clock">';
        str += '<input id="hour" class="in"   type="text" size="2" maxlength="2" onblur="this.value=formatNum2(this.value, \'hour\')" value="' + formatNum2(hour, 'hour') + '" />:';
        str += '<input id="minute" class="in" type="text" size="2" maxlength="2" onblur="this.value=formatNum2(this.value, \'minute\')" value="' + formatNum2(minute, 'minute') + '" />:';
        str += '<input id="second" class="in" type="text" size="2" maxlength="2" onblur="this.value=formatNum2(this.value, \'second\')" value="' + formatNum2(second, 'second') + '" />';
        str += '</form></div>';

        cnt.innerHTML = str;
        clock_set = 1;
    }
    
   

}

/**
 * Returns date from calendar.
 *
 * @param   string     date text
 */
function returnDate(d) {
    txt = d;
    if (dateType != 'date') {
        // need to get time
        h = parseInt(document.getElementById('hour').value,10);
        m = parseInt(document.getElementById('minute').value,10);
        s = parseInt(document.getElementById('second').value,10);
        if (dateType == 'datetime') {
            txt += ' ' + formatNum2(h, 'hour') + ':' + formatNum2(m, 'minute') + ':' + formatNum2(s, 'second');
        } else {
            // timestamp
            txt += formatNum2(h, 'hour') + formatNum2(m, 'minute') + formatNum2(s, 'second');
        }
    }
  year = month = day = 0;
    dateField.value = txt;
    close_cal();
}