name_of_user_ret PHP Code Examples

Example #1

0

Show file

File: helper.php Project: Glavnyuk/hd.rustem

  <div class="panel-body">
	<h3 style=" margin-top: 0px; "><?php 
            echo make_html($fio['title']);
            ?>
</h3>
	<p><?php 
            echo $fio['message'];
            ?>
</p>
	<hr>
	
	<p class="text-right"><small class="text-muted"><?php 
            echo lang('HELPER_pub');
            ?>
: <?php 
            echo nameshort(name_of_user_ret($fio['user_init_id']));
            ?>
</small><br><small class="text-muted"><?php 
            echo lang('HELPER_date');
            ?>
: <?php 
            echo $fio['dt'];
            ?>
</small>
	<br><a id="print_t" class="btn btn-default btn-xs"> <i class="fa fa-print"></i> <?php 
            echo lang('HELPER_print');
            ?>
</a>
    	</p>
  </div>
</div>

Example #2

0

Show file

File: all_stats.php Project: Joker1982/inv

            //$ee - массив id отделов, на которые у меня есть права
            //$ec - массив id отделов пользователей
            //если какой-то отдел совпадает вывести
            $stmt = $dbConnection->prepare('SELECT id, unit from users');
            $stmt->execute();
            $result = $stmt->fetchAll();
            if (!empty($result)) {
                foreach ($result as $row) {
                    $ec = explode(",", $row['unit']);
                    $result = array_intersect($ee, $ec);
                    if ($result) {
                        ?>

<tr>
                    <td style="width: 200px;"><small><?php 
                        echo name_of_user_ret($row['id']);
                        ?>
</small></td>
                    <td style=""><small class="text-danger"><center><?php 
                        echo get_user_status($row['id']);
                        ?>
</center></small></td>
                    <td style=""><small class="text-danger"><center><?php 
                        echo get_total_tickets_free($row['id']);
                        ?>
</center></small></td>
                    <td style=""><small class="text-warning"><center><?php 
                        echo get_total_tickets_lock($row['id']);
                        ?>
</center></small></td>
                    <td style=""><small class="text-success"><center><?php

Example #3

0

Show file

File: actions.php Project: Joker1982/inv

            ?>

            <div class="alert alert-success"><i class="fa fa-check"></i> <?php 
            echo lang('TICKET_msg_unlock');
            ?>
</div>

        <?php 
        }
        if ($mode == "update_to") {
            $tid = $_POST['ticket_id'];
            $to = $_POST['to'];
            $tou = $_POST['tou'];
            $tom = $_POST['tom'];
            if (strlen($tom) > 2) {
                $x_refer_comment = '<small class=\\"text-muted\\">' . nameshort(name_of_user_ret($_SESSION['helpdesk_user_id'])) . ' ' . lang('REFER_comment_add') . ' (' . date(' d.m.Y h:i:s') . '):</small> ' . strip_tags(xss_clean($_POST['tom']));
                $stmt = $dbConnection->prepare('update tickets set 
            unit_id=:to, 
            user_to_id=:tou, 
            msg=concat(msg,:br,:x_refer_comment), 
            lock_by=:n, 
            last_update=now() where id=:tid');
                $stmt->execute(array(':to' => $to, ':tou' => $tou, ':br' => '<br>', ':x_refer_comment' => $x_refer_comment, ':tid' => $tid, ':n' => '0'));
            } else {
                if (strlen($tom) <= 2) {
                    $stmt = $dbConnection->prepare('update tickets set 
            unit_id=:to, 
            user_to_id=:tou, 
            lock_by=:n, 
            last_update=now() where id=:tid');
                    $stmt->execute(array(':to' => $to, ':tou' => $tou, ':tid' => $tid, ':n' => '0'));

Example #4

0

Show file

File: list_content.inc.php Project: Glavnyuk/hd.rustem

                    echo $row['date_create'];
                    ?>
"></time></center></small></td>
                        <td style=" vertical-align: middle; "><small><?php 
                    echo nameshort(name_of_user_ret($row['user_init_id']));
                    ?>
</small></td>

                        <td style=" vertical-align: middle; "><small>
                                <?php 
                    echo $to_text;
                    ?>
                            </small></td>
                        <td style=" vertical-align: middle; "><small>
                                <?php 
                    echo nameshort(name_of_user_ret($row['ok_by']));
                    ?>
                            </small></td>
                        <td style=" vertical-align: middle; "><small><center>
                        <time id="c" datetime="<?php 
                    echo $row['ok_date'];
                    ?>
"></time>
                        </center></small></td>
                    </tr>
                <?php 
                }
                ?>
                </tbody>
            </table>
        <?php

Example #5

0

Show file

File: functions.inc.php Project: Joker1982/inv

function get_myname()
{
    $uid = $_SESSION['helpdesk_user_id'];
    $nu = name_of_user_ret($uid);
    $length = strlen(utf8_decode($nu));
    if ($length > 2) {
        $n = explode(" ", name_of_user_ret($uid));
        $t = $n[1] . " " . $n[2];
    } else {
        if ($length <= 2) {
            $t = "";
        }
    }
    //$n=explode(" ", name_of_user_ret($uid));
    return $t;
}

Example #6

0

Show file

File: ticket.php Project: Glavnyuk/hd.rustem

 }
 if ($arch == 0) {
     if ($status_ok == 1) {
         $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 {

Example #7

0

Show file

File: navbar.inc.php Project: Joker1982/inv

            </li>


        </ul>
        </li>

        <?php 
}
?>
        </ul>
        <ul class="nav navbar-nav navbar-right">

            <li class="dropdown">
                <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i> <?php 
echo nameshort(name_of_user_ret($_SESSION['helpdesk_user_id']));
?>
 <b class="caret"></b></a>
                <ul class="dropdown-menu">
                    <!--li <?php 
echo echoActiveClassIfRequestMatches("clients.php");
?>
 ><a href="clients.php"><i class="fa fa-users"></i> Клієнти</a></li-->
                    <li <?php 
echo echoActiveClassIfRequestMatches("profile");
?>
><a href="<?php 
echo $CONF['hostname'];
?>
profile"><i class="fa fa-cogs"></i> <?php 
echo lang('NAVBAR_profile');

Example #8

0

Show file

File: print_ticket.php Project: Glavnyuk/hd.rustem

session_start();
include "../functions.inc.php";
$rkeys = array_keys($_GET);
$CONF['title_header'] = lang('TICKET_name') . " #" . get_ticket_id_by_hash($rkeys[1]) . " - " . $CONF['name_of_firm'];
if (validate_user($_SESSION['helpdesk_user_id'], $_SESSION['code'])) {
    include "head.inc.php";
    $hn = $rkeys[1];
    $stmt = $dbConnection->prepare('SELECT
                           id, user_init_id, user_to_id, date_create, subj, msg, client_id, unit_id, status, hash_name, comment, last_edit, is_read, lock_by, ok_by, arch, ok_date, prio, last_update
                            from tickets
                            where hash_name=:hn');
    $stmt->execute(array(':hn' => $hn));
    $res1 = $stmt->fetchAll();
    if (!empty($res1)) {
        foreach ($res1 as $row) {
            $to_text = name_of_user_ret($row['user_to_id']);
            $date_today = date("d.m.Y");
            ?>
      <script>
    //window.print();
    </script>

   <div style="padding-top:100px;margin-right:50px;text-align:right;">
   <?php 
            echo lang('TICKET_t_from');
            ?>
: <?php 
            echo name_of_user($row['user_init_id']);
            ?>
<br>
   <?php

Example #9

0

Show file

File: mail.inc.php Project: Glavnyuk/hd.rustem

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";
    }
}

PHP name_of_user_ret Examples