Exemple #1
0
        ?>
		</small></center></th>
            
          </tr>
        </thead>
        <tbody>
        <?php 
        //include("../dbconnect.inc.php");
        //$results = mysql_query("SELECT id, fio, login, priv, unit, status from users;");
        //while ($row = mysql_fetch_assoc($results)) {
        //$getunit=get_unit_name($row['priv']);
        $stmt = $dbConnection->prepare('SELECT id, fio, login, priv, unit, status from users');
        $stmt->execute();
        $res1 = $stmt->fetchAll();
        foreach ($res1 as $row) {
            $unit = view_array(get_unit_name_return($row['unit']));
            $statuss = $row['status'];
            if ($row['priv'] == "0") {
                $priv = lang('USERS_p_1');
            } else {
                if ($row['priv'] == "1") {
                    $priv = lang('USERS_p_2');
                } else {
                    if ($row['priv'] == "2") {
                        $priv = lang('USERS_p_3');
                    }
                }
            }
            if ($statuss == "1") {
                $r = "";
            }
</center></th>
                    <th><center><?php 
                echo lang('t_list_a_date_ok');
                ?>
</center></th>
                </tr>
                </thead>
                <tbody>

                <?php 
                foreach ($res1 as $row) {
                    if ($row['user_to_id'] != 0) {
                        $to_text = "<div class=''>" . nameshort(name_of_user_ret($row['user_to_id'])) . "</div>";
                    }
                    if ($row['user_to_id'] == 0) {
                        $to_text = "<strong data-toggle=\"tooltip\" data-placement=\"bottom\" title=\"" . view_array(get_unit_name_return($row['unit_id'])) . "\">" . lang('t_list_a_all') . "</strong>";
                    }
                    ?>
                    <tr >
                        <td style=" vertical-align: middle; "><small><center><?php 
                    echo $row['id'];
                    ?>
</center></small></td>
                        <td style=" vertical-align: middle; "><small><a href="ticket?<?php 
                    echo $row['hash_name'];
                    ?>
"><?php 
                    cutstr(make_html($row['subj'], 'no'));
                    ?>
</a></small></td>
                        <td style=" vertical-align: middle; "><small><?php 
Exemple #3
0
      <div class="col-sm-4 text-right" ><strong ><small><?php 
    echo lang('PROFILE_priv');
    ?>
:</small></strong></div>
      <div class="col-sm-8"><small><?php 
    echo priv_status_name($usid);
    ?>
</small></div>
      </div>
      <div class="form-group">
      <div class="col-sm-4 text-right"><strong><small><?php 
    echo lang('PROFILE_priv_unit');
    ?>
:</small></strong></div>
      <div class="col-sm-8"><p><small><?php 
    echo view_array(get_unit_name_return(unit_of_user($_SESSION['helpdesk_user_id'])));
    ?>
</small></p></div>
      <div class="col-sm-12">
      <hr>
      </div>
      </div>
      <div class="form-group">
    <label for="login" class="col-sm-4 control-label"><?php 
    echo lang('P_login');
    ?>
</label>
        <div class="col-sm-8">
    <input autocomplete="off" name="login" type="" class="form-control input-sm" id="login" placeholder="<?php 
    echo lang('P_login');
    ?>
Exemple #4
0
            <div class="row">
                <div class="col-md-3"><h3><i class="fa fa-list-alt"></i> <?php 
    echo lang('LIST_title');
    ?>
</h3><span
                        class="text-muted">
                        
                        
                        <small>
                        	<em>
                        	<?php 
    if ($priv_val != "2") {
        ?>
								<span data-toggle="tooltip" data-placement="right" title="<?php 
        echo view_array($text);
        ?>
"><?php 
        echo lang('LIST_pin');
        ?>
: <?php 
        echo count($text);
        ?>
								</span>
								<?php 
    } else {
        if ($priv_val == "2") {
            echo $text;
        }
    }
    ?>
Exemple #5
0
function view_log($tid)
{
    global $dbConnection;
    $stmt = $dbConnection->prepare('SELECT msg,
							date_op, init_user_id, to_user_id, to_unit_id from ticket_log where
							ticket_id=:tid order by date_op DESC');
    $stmt->execute(array(':tid' => $tid));
    $re = $stmt->fetchAll();
    if (!empty($re)) {
        ?>

							<div class="col-md-12" style=" padding-left: 0px; padding-right: 0px; ">


								<div class="panel panel-default">
									<div class="panel-body" style="max-height: 400px; scroll-behavior: initial; overflow-y: scroll;">

										<table class="table table-hover">
											<thead>
											<tr>
												<th><center><small><?php 
        echo lang('TICKET_t_date');
        ?>
</small></center>	</th>
												<th><center><small><?php 
        echo lang('TICKET_t_init');
        ?>
	</small></center></th>
												<th><center><small><?php 
        echo lang('TICKET_t_action');
        ?>
 	</small></center></th>
												<th><center><small><?php 
        echo lang('TICKET_t_desc');
        ?>
	</small></center></th>


											</tr>
											</thead>

											<tbody>
											<?php 
        foreach ($re as $row) {
            $t_action = $row['msg'];
            if ($t_action == 'refer') {
                $icon_action = "fa fa-long-arrow-right";
                $text_action = "" . lang('TICKET_t_a_refer') . " <br>" . view_array(get_unit_name_return($row['to_unit_id'])) . "<br>" . name_of_user_ret($row['to_user_id']);
            }
            if ($t_action == 'arch') {
                $icon_action = "fa fa-archive";
                $text_action = lang('TICKET_t_a_arch');
            }
            if ($t_action == 'ok') {
                $icon_action = "fa fa-check-circle-o";
                $text_action = lang('TICKET_t_a_ok');
            }
            if ($t_action == 'no_ok') {
                $icon_action = "fa fa-circle-o";
                $text_action = lang('TICKET_t_a_nook');
            }
            if ($t_action == 'lock') {
                $icon_action = "fa fa-lock";
                $text_action = lang('TICKET_t_a_lock');
            }
            if ($t_action == 'unlock') {
                $icon_action = "fa fa-unlock";
                $text_action = lang('TICKET_t_a_unlock');
            }
            if ($t_action == 'create') {
                $icon_action = "fa fa-star-o";
                $text_action = lang('TICKET_t_a_create');
            }
            if ($t_action == 'edit_prio') {
                $icon_action = "fa fa-pencil-square";
                $text_action = lang('TICKET_t_a_e_prio');
            }
            if ($t_action == 'edit_msg') {
                $icon_action = "fa fa-pencil-square";
                $text_action = lang('TICKET_t_a_e_text');
            }
            if ($t_action == 'edit_subj') {
                $icon_action = "fa fa-pencil-square";
                $text_action = lang('TICKET_t_a_e_subj');
            }
            if ($t_action == 'comment') {
                $icon_action = "fa fa-comment";
                $text_action = lang('TICKET_t_a_com');
            }
            ?>
												<tr>
													<td style="width: 100px; vertical-align: inherit;"><small><center>
													
													<time id="c" datetime="<?php 
            echo $row['date_op'];
            ?>
"></time>
													
													</center></small></td>
													<td style=" width: 200px; vertical-align: inherit;"><small><center><?php 
            echo name_of_user($row['init_user_id']);
            ?>
</center></small></td>
													<td style=" width: 50px; vertical-align: inherit;"><small><center><i class="<?php 
            echo $icon_action;
            ?>
"></i>  </center></small></td>
													<td style=" width: 200px; vertical-align: inherit;"><small><?php 
            echo $text_action;
            ?>
</small></td>


												</tr>
											<?php 
        }
        ?>
											</tbody>
										</table>
									</div>
								</div>





							</div>



						<?php 
    }
}
Exemple #6
0
         $st = "<span class=\"label label-success\"><i class=\"fa fa-check-circle\"></i> " . lang('TICKET_status_ok') . " " . nameshort(name_of_user_ret($ok_by)) . "</span>";
     }
     if ($status_ok == 0) {
         if ($lock_by != 0) {
             $st = "<span class=\"label label-warning\"><i class=\"fa fa-gavel\"></i> " . lang('TICKET_status_lock') . " " . name_of_user_ret($lock_by) . "</span>";
         }
         if ($lock_by == 0) {
             $st = "<span class=\"label label-primary\"><i class=\"fa fa-clock-o\"></i> " . lang('TICKET_status_new') . "</span>";
         }
     }
 }
 if ($row['user_to_id'] != 0) {
     $to_text = "<div class=''>" . name_of_user_ret($row['user_to_id']) . "</div>";
 }
 if ($row['user_to_id'] == 0) {
     $to_text = "<strong>" . lang('t_list_a_all') . "</strong> " . lang('T_from') . " " . view_array(get_unit_name_return($row['unit_id']));
 }
 if ($row['is_read'] == "0") {
     $res = $dbConnection->prepare("update tickets set is_read=:n where id=:tid");
     $res->execute(array(':n' => '1', ':tid' => $tid));
 }
 if ($lock_by != "0") {
     if ($lock_by == $_SESSION['helpdesk_user_id']) {
         $status_lock = "me";
         //$lock_disabled="";
         $lock_text = "<i class=\"fa fa-unlock\"></i> " . lang('TICKET_action_unlock') . "";
         $lock_status = "unlock";
     } else {
         $status_lock = "you";
         $lock_status = "unlock";
         $lock_text = "<i class=\"fa fa-unlock\"></i> " . lang('TICKET_action_unlock') . "";
Exemple #7
0
function send_mail_to($type, $tid)
{
    global $CONF, $CONF_MAIL, $dbConnection;
    $MAIL_login = lang('login');
    $MAIL_pass = lang('pass');
    $MAIL_new = lang('MAIL_new');
    $MAIL_code = lang('MAIL_code');
    $MAIL_2link = lang('MAIL_2link');
    $MAIL_info = lang('MAIL_info');
    $MAIL_created = lang('MAIL_created');
    $MAIL_to = lang('MAIL_to');
    $MAIL_prio = lang('MAIL_prio');
    $MAIL_worker = lang('MAIL_worker');
    $MAIL_msg = lang('MAIL_msg');
    $MAIL_subj = lang('MAIL_subj');
    $MAIL_text = lang('MAIL_text');
    $mfrom_name = lang('MAIL_name');
    $mfrom_mail = $CONF_MAIL['from'];
    $headers = 'MIME-Version: 1.0' . "\r\n";
    $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
    $headers .= "From: =?utf-8?B?" . base64_encode($mfrom_name) . "?= <{$mfrom_mail}>\n";
    'Reply-To: ' . $CONF_MAIL['from'] . "\r\n" . 'X-Mailer: PHP/' . phpversion();
    if ($type == "new_all") {
        $stmt = $dbConnection->prepare('SELECT user_init_id,user_to_id,date_create,subj,msg, client_id, unit_id, status, hash_name, prio,last_update FROM tickets where id=:tid');
        $stmt->execute(array(':tid' => $tid));
        $max_id_ticket = $stmt->fetch(PDO::FETCH_ASSOC);
        $unit_id = $max_id_ticket['unit_id'];
        $client_id = $max_id_ticket['user_to_id'];
        $user_init_id = $max_id_ticket['user_init_id'];
        $wclient_id = $max_id_ticket['client_id'];
        $s = $max_id_ticket['subj'];
        $m = $max_id_ticket['msg'];
        $h = $max_id_ticket['hash_name'];
        $prio = lang('t_list_a_p_norm');
        if ($max_id_ticket['prio'] == "0") {
            $prio = lang('t_list_a_p_low');
        } else {
            if ($max_id_ticket['prio'] == "2") {
                $prio = lang('t_list_a_p_high');
            }
        }
        $uin = name_of_user_ret($user_init_id);
        $nou = name_of_client_ret($wclient_id);
        if ($max_id_ticket['user_to_id'] != 0) {
            $to_text = "" . name_of_user_ret($client_id) . "";
        } else {
            if ($max_id_ticket['user_to_id'] == 0) {
                $to_text = lang('t_list_a_all') . " " . view_array(get_unit_name_return($unit_id));
            }
        }
        $stmt = $dbConnection->prepare('SELECT email, unit, login FROM users where status=:n');
        $stmt->execute(array(':n' => '1'));
        $res1 = $stmt->fetchAll();
        foreach ($res1 as $qrow) {
            $u = explode(",", $qrow['unit']);
            foreach ($u as $val) {
                if ($val == $unit_id) {
                    //echo $val."==".$unit_id."=".$qrow['email'];
                    if (!is_null($qrow['email'])) {
                        //echo $qrow['email'];
                        $to = $qrow['email'];
                        $tl = $qrow['login'];
                        $subject = lang('TICKET_name') . ' #' . $tid . " (" . lang('t_list_a_all') . ") ";
                        $message = <<<EOBODY
<div style="background: #ffffff; border: 1px solid gray; border-radius: 6px; font-family: Arial,Helvetica,sans-serif; font-size: 12px; margin: 9px 17px 13px 17px; padding: 11px;">
<p style="font-family: Arial, Helvetica, sans-serif; font-size:18px; text-align:center;">{$MAIL_new}!</p>
<table width="100%" cellpadding="3" cellspacing="0">
  <tbody>
    <tr id="tr_">
      <td width="15%" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_code}:</td>
      <td width="36%" align="center" valign="middle" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 19px;"><b>#{$tid}</b></td>
      <td width="49%" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;"><p style="font-family: Arial, Helvetica, sans-serif; font-size:11px; text-align:center;"> <a href='{$CONF['hostname']}ticket?{$h}'>{$MAIL_2link}</a>.</p></td>
    </tr>
  </tbody>
</table>
<br />
<table width="100%" cellspacing="0" cellpadding="3" style="">
  <tr style="border: 1px solid #ddd;">
    <td colspan="2" style="border: 1px solid #ddd; background-color: #f5f5f5; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;"><center>
      <strong>{$MAIL_info} </strong>
    </center></td>


  </tr>
  <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_created}:</td>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$uin}</td>
  </tr>
  <tr>
    <td  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_to}:</td>
    <td  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$to_text}</td>
  </tr>
    <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_prio}:</td>
    <td style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$prio}</td>
  </tr>
  <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_worker}:</td>
    <td style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$nou}</td>
  </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2"  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px; background-color: #f5f5f5;"><center>
      <strong>{$MAIL_msg}</strong>
    </center></td>
  </tr>
  <tr>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_subj}:</td>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$s}</td>
  </tr>
    <tr>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_text}:</td>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$m}</td>
  </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
  </tr>  
 
</table>
</center>

</div>
EOBODY;
                        send_mail($to, $subject, $message);
                    }
                }
            }
        }
    }
    if ($type == "new_coord") {
        $stmt = $dbConnection->prepare('SELECT user_init_id,user_to_id,date_create,subj,msg, client_id, unit_id, status, hash_name, prio,last_update FROM tickets where id=:tid');
        $stmt->execute(array(':tid' => $tid));
        $max_id_ticket = $stmt->fetch(PDO::FETCH_ASSOC);
        $unit_id = $max_id_ticket['unit_id'];
        $client_id = $max_id_ticket['user_to_id'];
        $user_init_id = $max_id_ticket['user_init_id'];
        $wclient_id = $max_id_ticket['client_id'];
        $s = $max_id_ticket['subj'];
        $m = $max_id_ticket['msg'];
        $h = $max_id_ticket['hash_name'];
        $prio = lang('t_list_a_p_norm');
        if ($max_id_ticket['prio'] == "0") {
            $prio = lang('t_list_a_p_low');
        } else {
            if ($max_id_ticket['prio'] == "2") {
                $prio = lang('t_list_a_p_high');
            }
        }
        $uin = name_of_user_ret($user_init_id);
        $nou = name_of_client_ret($wclient_id);
        if ($max_id_ticket['user_to_id'] != 0) {
            $to_text = "" . name_of_user_ret($client_id) . "";
        } else {
            if ($max_id_ticket['user_to_id'] == 0) {
                $to_text = lang('t_list_a_all') . " " . view_array(get_unit_name_return($unit_id));
            }
        }
        /////////////////////////////////
        /*$qstring = "SELECT email, unit,login FROM users where status='1' and (priv='0' || priv='2');";
        $qresult = mysql_query($qstring);//query the database for entries containing the term
        while ($qrow = mysql_fetch_array($qresult,MYSQL_ASSOC)) {
        */
        $stmt = $dbConnection->prepare('SELECT email, unit,login FROM users where status=:n and (priv=:n1 || priv=:n2)');
        $stmt->execute(array(':n' => '1', ':n1' => '0', ':n2' => '2'));
        $res1 = $stmt->fetchAll();
        foreach ($res1 as $qrow) {
            $u = explode(",", $qrow['unit']);
            foreach ($u as $val) {
                if ($val == $unit_id) {
                    //echo $val."==".$unit_id."=".$qrow['email'];
                    if (!is_null($qrow['email'])) {
                        //echo $qrow['login'];
                        $to = $qrow['email'];
                        $tl = $qrow['login'];
                        $subject = lang('TICKET_name') . ' #' . $tid . " (" . lang('t_LIST_worker_to') . ")";
                        $message = <<<EOBODY
<div style="background: #ffffff; border: 1px solid gray; border-radius: 6px; font-family: Arial,Helvetica,sans-serif; font-size: 12px; margin: 9px 17px 13px 17px; padding: 11px;">
<p style="font-family: Arial, Helvetica, sans-serif; font-size:18px; text-align:center;">{$MAIL_new}!</p>
<table width="100%" cellpadding="3" cellspacing="0">
  <tbody>
    <tr id="tr_">
      <td width="15%" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_code}:</td>
      <td width="36%" align="center" valign="middle" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 19px;"><b>#{$tid}</b></td>
      <td width="49%" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;"><p style="font-family: Arial, Helvetica, sans-serif; font-size:11px; text-align:center;"> <a href='{$CONF['hostname']}ticket?{$h}'>{$MAIL_2link}</a>.</p></td>
    </tr>
  </tbody>
</table>
<br />
<table width="100%" cellspacing="0" cellpadding="3" style="">
  <tr style="border: 1px solid #ddd;">
    <td colspan="2" style="border: 1px solid #ddd; background-color: #f5f5f5; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;"><center>
      <strong>{$MAIL_info} </strong>
    </center></td>


  </tr>
  <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_created}:</td>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$uin}</td>
  </tr>
  <tr>
    <td  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_to}:</td>
    <td  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$to_text}</td>
  </tr>
    <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_prio}:</td>
    <td style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$prio}</td>
  </tr>
  <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_worker}:</td>
    <td style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$nou}</td>
  </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2"  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px; background-color: #f5f5f5;"><center>
      <strong>{$MAIL_msg}</strong>
    </center></td>
  </tr>
  <tr>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_subj}:</td>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$s}</td>
  </tr>
    <tr>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_text}:</td>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$m}</td>
  </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
  </tr>  
 
</table>
</center>

</div>
EOBODY;
                        send_mail($to, $subject, $message);
                    }
                }
            }
        }
    }
    if ($type == "new_user") {
        /*$queryid_ticket="SELECT user_init_id,user_to_id,date_create,subj,msg, client_id, unit_id, status, hash_name, prio,last_update FROM tickets where id='$tid'";
          $res1_ticket = mysql_query($queryid_ticket) or die(mysql_error());
          $max_id_ticket= mysql_fetch_assoc( $res1_ticket );
          */
        $stmt = $dbConnection->prepare('SELECT user_init_id,user_to_id,date_create,subj,msg, client_id, unit_id, status, hash_name, prio,last_update FROM tickets where id=:tid');
        $stmt->execute(array(':tid' => $tid));
        $max_id_ticket = $stmt->fetch(PDO::FETCH_ASSOC);
        $unit_id = $max_id_ticket['unit_id'];
        $client_id = $max_id_ticket['user_to_id'];
        $user_init_id = $max_id_ticket['user_init_id'];
        $wclient_id = $max_id_ticket['client_id'];
        $s = $max_id_ticket['subj'];
        $m = $max_id_ticket['msg'];
        $h = $max_id_ticket['hash_name'];
        $prio = lang('t_list_a_p_norm');
        if ($max_id_ticket['prio'] == "0") {
            $prio = lang('t_list_a_p_low');
        } else {
            if ($max_id_ticket['prio'] == "2") {
                $prio = lang('t_list_a_p_high');
            }
        }
        $uin = name_of_user_ret($user_init_id);
        $nou = name_of_client_ret($wclient_id);
        if ($max_id_ticket['user_to_id'] != 0) {
            $to_text = "" . name_of_user_ret($client_id) . "";
        } else {
            if ($max_id_ticket['user_to_id'] == 0) {
                $to_text = lang('t_list_a_all') . " " . view_array(get_unit_name_return($unit_id));
            }
        }
        //$results = mysql_query("SELECT email from users where id='$client_id' and status='1';");
        //while ($row = mysql_fetch_assoc($results)) {
        $stmt = $dbConnection->prepare('SELECT email,login from users where id=:client_id and status=:n and priv=:n1');
        $stmt->execute(array(':n' => '1', ':client_id' => $client_id, ':n1' => '2'));
        $res1 = $stmt->fetchAll();
        foreach ($res1 as $row) {
            if (!is_null($row['email'])) {
                $to = $row['email'];
                $tl = $row['login'];
                $subject = lang('TICKET_name') . ' #' . $tid . " (" . lang('t_LIST_person') . ")";
                $message = <<<EOBODY
<div style="background: #ffffff; border: 1px solid gray; border-radius: 6px; font-family: Arial,Helvetica,sans-serif; font-size: 12px; margin: 9px 17px 13px 17px; padding: 11px;">
<p style="font-family: Arial, Helvetica, sans-serif; font-size:18px; text-align:center;">{$MAIL_new}!</p>
<table width="100%" cellpadding="3" cellspacing="0">
  <tbody>
    <tr id="tr_">
      <td width="15%" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_code}:</td>
      <td width="36%" align="center" valign="middle" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 19px;"><b>#{$tid}</b></td>
      <td width="49%" style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;"><p style="font-family: Arial, Helvetica, sans-serif; font-size:11px; text-align:center;"><a href='{$CONF['hostname']}ticket?{$h}'>{$MAIL_2link}</a></p></td>
    </tr>
  </tbody>
</table>
<br />
<table width="100%" cellspacing="0" cellpadding="3" style="">
  <tr style="border: 1px solid #ddd;">
    <td colspan="2" style="border: 1px solid #ddd; background-color: #f5f5f5; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;"><center>
      <strong>{$MAIL_info} </strong>
    </center></td>


  </tr>
  <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_created}:</td>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$uin}</td>
  </tr>
  <tr>
    <td  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_to}:</td>
    <td  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$to_text}</td>
  </tr>
    <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_prio}:</td>
    <td style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$prio}</td>
  </tr>
  <tr>
    <td style="border: 1px solid #ddd; font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_worker}:</td>
    <td style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$nou}</td>
  </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2"  style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px; background-color: #f5f5f5;"><center>
      <strong>{$MAIL_msg}</strong>
    </center></td>
  </tr>
  <tr>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_subj}:</td>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$s}</td>
  </tr>
    <tr>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$MAIL_text}:</td>
    <td   style="border: 1px solid #ddd;font-family: Arial, Helvetica, sans-serif;
\tfont-size: 12px;">{$m}</td>
  </tr>
    <tr>
    <td colspan="5">&nbsp;</td>
  </tr>  
 
</table>
</center>

</div>
EOBODY;
                send_mail($to, $subject, $message);
            }
        }
        //echo "dd";
    }
}