#!/usr/bin/perl -w
use CGI qw(:cookie);
use CGI qw(:param);
use DBI;
#use CGI::Carp 'fatalsToBrowser';
$SSID=cookie('ssid');

$sqldriver="mysql";
$sqldatabase="b75346";
$sqlhostname="78.108.81.230";
$sqluser="u75346";
$sqlpassword="2015xlitmysql";
@rec=();
$dbh= DBI->connect("DBI:mysql:$sqldatabase;host=$sqlhostname",$sqluser,$sqlpassword) || die "can't connect to $sqldatabase";
if ($SSID)
{
    $sth=$dbh->prepare( "SELECT * from sns WHERE ssid='$SSID\'" );
    $sth->execute;
    @rec=$sth->fetchrow_array;
}
@tasks_importances=("","Маловажно","Средне","Важно!");
@visits_status=('<strong style="color:yellow">Нерассмотрен</strong>','<strong style="color:green">Подтвержден</strong>','<strong style="color:red">Неподтвержден</strong>');
$session_expire=$rec[4];
if(@rec>0)
{
    if ($rec[4] < time()) #session has expired
    {
        $template_data="Истекло время Вашей сессии. Войдите повторно";
        $template_title="XL IT-Service :: Личный кабинет :: Сессия истекла";
        require("./prepare_template");
        print $template; 
        die; 
    }
}


$sth=$dbh->prepare( "SELECT * from usr WHERE login='@rec[2]\'" );
$sth->execute;
@c_rec=$sth->fetchrow_array;
if ($c_rec[12]==1)
{
	@tasks_progress=("<strong style=\"color:red\">Не рассмотрена</strong>","В обработке","<strong>Сообщение</strong>","Жду ответа","<strong style=\"color:red\">ожидает подверждения</strong>","<strong style=\"color:green\">Завершена</strong>","<strong style=\"color:yellow\">Отменена</strong>");
	$sth=$dbh->prepare( "SELECT name from org GROUP BY name ORDER BY added" );
	$sth->execute;
    $inorg_options='';
    while(@org_rec=$sth->fetchrow_array)
    {
    	$inorg_options.="<option value=\"@org_rec[0]\">@org_rec[0]</option>";
    }	
    $template_data="<div align=\"right\" style=\"font-size:9px; font-family:Geneva, Arial, Helvetica, sans-serif;\">Сессия активна до ".localtime($session_expire)." <strong onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color=''\" onClick=\"commonLOGOUT()\" style=\"font-size:12px; font-weight:500; cursor:pointer\">LOGOUT</strong></div><h4>Личный кабинет XL IT-Service</h4>";
    $template_data.='
    <script language="javascript" type="text/javascript" src="/JS/icontrolpage.js"></script>
    <script language="javascript" type="text/javascript" src="/JS/commoncontrolpage.js"></script>
    <div align="left">
    Текущая организация: <select id="inorg">'.$inorg_options.'</select> <strong style="cursor:pointer;" onClick="ishowAddOrg()">Добавить</strong><br><br>
    <strong style="cursor:pointer" onClick="ishowAsks()">Заявки по организации</strong> <input type="checkbox" id="onlyactiveasks" checked>Только активные<br> <br>
    <strong style="cursor:pointer" onClick="ishowVisits()">Визиты по организации</strong> |
    <strong style="cursor:pointer" onClick="ishowRegVisit()">Добавить визит</strong><br><br>
    <strong style="cursor:pointer" onClick="ishowHardware()">Оборудование</strong> | <strong style="cursor:pointer" onClick="ishowRegHardware()">Добавить оборудование</strong><br>Полный отчет эвереста(имя файла - инв.номером ПК): <form action="/cgi-bin/everestreportparcer" id="everestreport_form" enctype="multipart/form-data"><input type="file" name="report" id="everestreport_file" style="background:#f8c85f; border:1px #FFFF00;"><input type="hidden" name="org" id="reportorg" value=""><input type="submit" value="загрузить" style="background:#f8c85f; border:1px #FFFF00;" onClick="document.getElementById(\'reportorg\').value=document.getElementById(\'inorg\').value"></form><hr>    
    ';
    
    $sth=$dbh->prepare( "SELECT * FROM tasks WHERE status=0 ORDER BY date DESC, org ASC, importance DESC;" );
    $sth->execute;
    
    if ($sth->errstr eq '')
    {
    	$template_data.='Общий Список заявок <strong style="cursor:pointer;" onClick="showhideTasksList(this)">Скрыть</strong><table border="0" cellpadding="2" cellspacing="0" width="100%" id="tasks_list" style="display:; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:9px; font-stretch:condensed; font-style:normal; font-variant:normal; font-weight:700">
        				<tr bgcolor="#FFCC00">
                        <td>Дата</td>
                        <td>Организация</td>
                        <td>Заголовок</td>
                        <td>Приоритет</td>
                        <td>Категория</td>
                        <td>Статус</td>
                        <td>Исполнитель</td>
                        </tr>';
    	while(@t_arr=$sth->fetchrow_array)
        {
        
            $sth_usr=$dbh->prepare( "SELECT * FROM usr WHERE login='$t_arr[11]\';" );
            $sth_usr->execute;
            @usr_arr=$sth_usr->fetchrow_array;
            $accepted_user='';
            if (@usr_arr>0)
            {
                $accepted_user="$usr_arr[3] $usr_arr[4]";
            }    
            @t_date=localtime($t_arr[4]);    
        	$template_data.='
            <tr style="cursor:pointer" onClick="ishowTask(\''.$t_arr[0].'\')" onMouseOver="this.style.background=\'yellow\';" onMouseOut="this.style.background=\'\';">
                <td nowrap>'.($t_date[3]).'.'.($t_date[4]+1).'.'.($t_date[5]+1900).'</td>
                <td>'.$t_arr[2].'</td>
                <td>'.$t_arr[1].'</td>
                <td>'.$tasks_importances[$t_arr[7]].'</td>
                <td>'.$t_arr[5].'</td>
                <td nowrap>'.$tasks_progress[$t_arr[10]].'</td>
                <td nowrap>'.$accepted_user.'</td>
            </tr>';
            		
        }
        $template_data.='</table></div>';
    }	          

}
elsif($c_rec[12]==2)
{
	@tasks_progress=("Размещена","В обработке","<strong>Собщение отправлено</strong>","Сообщение","<strong style=\"color:red\">НЕОБХОДИМО ПОДТВЕРДИТЬ!</strong>","<strong style=\"color:green\">Завершена</strong>","<strong style=\"color:yellow\">Отменена</strong>");
	$template_data='<script language="javascript" type="text/javascript" src="/JS/controlpage.js"></script>
    				<script language="javascript" type="text/javascript" src="/JS/commoncontrolpage.js"></script>';
	$template_data.="<div align=\"right\" style=\"font-size:9px; font-family:Geneva, Arial, Helvetica, sans-serif;\">Сессия активна до ".localtime($session_expire)." <strong onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color=''\" onClick=\"commonLOGOUT()\" style=\"font-size:12px; font-weight:500; cursor:pointer\">LOGOUT</strong></div><h4>Личный кабинет</h4>";
	$template_data.='<input type="hidden" id="inorg" value="'.$c_rec[6].'">
  
    <div align="left">Информация о текущих активных заявках | 
    <strong style="cursor:pointer;" id="cp_showhide_acive_tasks" onClick="showhideTasksList(this)">Показать</strong> | 
    <strong style="cursor:pointer;" onClick="showAddTask()">Добавить заявку</strong></div>
    <table border="0" cellpadding="2" cellspacing="0" width="100%" id="tasks_list" style="display:none; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; font-stretch:condensed; font-style:normal; font-variant:normal; font-weight:700">
        <tr bgcolor="#FF9900">
        	<td>#</td>
            <td>Дата</td>
            <td>Заголовок</td>
            <td>Категория</td>
            <td>Статус</td>
            <td>Опции</td>
        </tr>';
    $sth=$dbh->prepare( "SELECT * FROM tasks WHERE status=0 AND org='$c_rec[6]\' ORDER BY date DESC, importance DESC;" );
    $sth->execute;
    if ($sth->errstr eq '')
    { 
    	while(@t_arr=$sth->fetchrow_array)
        {
        	if($t_arr[10]==4)
            {
            	$done_link="<img src=\"/img/green_ok.png\" alt=\"Подтвердить выполнение\" title=\"Подтвердить выполнение\" onClick=\"putDoneTask('$t_arr[0]')\">";
            }
            else
            {
            	$done_link='';	
            }
            @t_date=localtime($t_arr[4]);
        	$template_data.='
            <tr onMouseOver="this.style.background=\'grey\';" onMouseOut="this.style.background=\'\';">
                <td style="font-size:9px" nowrap>'.$t_arr[0].'</td>
                <td style="font-size:9px" nowrap>'.($t_date[3]).'.'.($t_date[4]+1).'.'.($t_date[5]+1900).'</td>
                <td align="left">'.$t_arr[1].'</td>
                <td>'.$t_arr[5].'</td>
                <td nowrap>'.$tasks_progress[$t_arr[10]].'</td>
                <td nowrap>'.
                "<img src=\"/img/blue_info.png\" alt=\"Просмотреть заявку\" title=\"Просмотреть заявку\" onClick=\"showTask('$t_arr[0]')\">
                $done_link
                <img src=\"/img/red_stop.png\" alt=\"Отменить заявку\" title=\"Отменить заявку\" onClick=\"putCancelTask('$t_arr[0]')\">"
                .'</td>
            </tr>
            ';	
        }
    }           	
	$template_data.='</table>';  
    
	$template_data.='  
    <div align="left">Информация о визитах | 
    <strong style="cursor:pointer;" id="cp_showhide_visits" onClick="showhideList(this,\'visits_list\')">Показать</strong>
    <table border="0" cellpadding="2" cellspacing="0" width="100%" id="visits_list" style="display:none; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; font-stretch:condensed; font-style:normal; font-variant:normal; font-weight:700">
        <tr bgcolor="#FF9900">
        	<td>#</td>
            <td>Дата</td>
            <td>Заявка</td>
            <td>Исполнитель</td>
            <td>Стоимость</td>
            <td>Статус</td>
            <td>Опции</td>
        </tr>';
    $sth=$dbh->prepare( "SELECT * FROM visits WHERE org='$c_rec[6]\' ORDER BY vtime DESC;" );
    $sth->execute;
    if ($sth->errstr eq '')
    { 
    	while(@t_arr=$sth->fetchrow_array)
        {           
            @t_date=localtime($t_arr[1]);
            
            $task_caption='';
            $sth_task=$dbh->prepare( "SELECT * FROM tasks WHERE id='$t_arr[4]\';" );
            $sth_task->execute;
            if ($sth_task->errstr eq '')
            {
            	@task_arr=$sth_task->fetchrow_array;
                if($task_arr[10]=='4')
                {
                	$task_caption="<strong style=\"color:red\">$task_arr[1]</strong>";
                }
                elsif($task_arr[10]=='5')
                {
                	$task_caption="<strong style=\"color:green\">$task_arr[1]</strong>";
                }
                elsif($task_arr[10]=='5')
                {
                	$task_caption="<strong style=\"color:yellow; font-style:italic\">$task_arr[1]</strong>";
                }
                else
                {
                	$task_caption="$task_arr[1]";
                }                                            
            }#TASK CONTENT
            
            $visitor_name='';
            $sth_visitor=$dbh->prepare( "SELECT * FROM usr WHERE login='$t_arr[3]\';" );
            $sth_visitor->execute;
            if ($sth_visitor->errstr eq '')
            {
            	@visitor_arr=$sth_visitor->fetchrow_array;
                $visitor_name="$visitor_arr[3] $visitor_arr[4]";		
            }#VISITOR DATA                        
        	$template_data.='
            <tr onMouseOver="this.style.background=\'grey\';" onMouseOut="this.style.background=\'\';">
            	<td style="font-size:9px" nowrap>'.$t_arr[0].'</td>
                <td style="font-size:9px" nowrap>'.($t_date[3]).'.'.($t_date[4]+1).'.'.($t_date[5]+1900).'</td>
                <td align="left">'.$task_caption.'</td>
                <td>'.$visitor_name.'</td>
                <td nowrap>'.$t_arr[6].'</td>
                <td nowrap>'.$visits_status[$t_arr[7]].'</td>
                <td nowrap>'.
                $done_link
                ."<img src=\"/img/green_ok.png\" alt=\"Подтвердить визит\" title=\"Подтвердить визит\" onClick=\"putDoneVisit('$t_arr[0]','$task_arr[0]')\">
                <img src=\"/img/red_brick.png\" alt=\"Сделать неподтвержденным\" title=\"Сделать неподтвержденным\" onClick=\"putUnDoneVisit('$t_arr[0]')\">"
                .'</td>
            </tr>
            ';	
        }
    }           	
	$template_data.='</table>';           			
}
else
{
	$template_data.='<h1>Недостаточно прав для работы с системой.</h1> <strong>Обратитесь к администратору сайта</strong>';
    require("./prepare_template");
    print $template;
    die;    
}

$template_data.='
	<div id="container_bg" style="height:0px; width::0px; background:url(/img/blackbg.png); position:fixed; top:0px; left:0px; display:none" onClick="hideContainer()"></div>
    <div id="container" style="position:absolute; display:none; width:100%; left:0px; top:0px;" align="center" >
        <table border="0" cellpadding="0" cellspacing="0" width="800">
        <tr>
            <td width="20" height="20"><img src="/img/container_border_corner_left_top.png"></td>
            <td background="/img/container_border_top.png" align="left">|<strong style="cursor:pointer;" onClick="hideContainer()">ЗАКРЫТЬ</strong>| клик за пределами закроет окно </td>
            <td><img src="/img/container_border_corner_right_top.png" width="20" height="20"></td>
        </tr>
        <tr>
            <td background="/img/container_border_left.png"></td>
            
            <td id="text_container" bgcolor="#df9439" style="border:dashed 1px #555555"></td>
            
            <td background="/img/container_border_right.png"></td>
        </tr>
        <tr>
            <td width="20" height="20"><img src="/img/container_border_corner_left_bottom.png" width="20" height="20"></td>
            <td background="/img/container_border_bottom.png" align="right">клик за пределами закроет окно |<strong style="cursor:pointer;" onClick="hideContainer()">ЗАКРЫТЬ</strong></td>
            <td width="20" height="20"><img src="/img/container_border_corner_right_bottom.png" width="20" height="20"></td>
        </tr>
        </table>
    </div>    
    ';
$template_title="XL IT-Service :: Личный кабинет :: $c_rec[3] $c_rec[4] $c_rec[5] :: $c_rec[6] ";
require("./prepare_template");
print $template;