-
Notifications
You must be signed in to change notification settings - Fork 0
/
approved-program-director.php
173 lines (148 loc) · 9.11 KB
/
approved-program-director.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
<?php
session_start();
include_once ('auth.php');
require_once('connect.php');
$result="";$items='';$mail_info_sent=false;$password='';
//if a program director is being sent information
if(isset($_REQUEST['pd'])){
$qry="SELECT * FROM `tblapproveduserlist` WHERE `EmailAddress` LIKE (SELECT EmailAddress FROM `tblprogramdirectors` WHERE `tblprogramdirectors`.CustomerID='0' AND `tblprogramdirectors`.ShipToID='0' AND `tblprogramdirectors`.EEStatus!='A' AND `tblprogramdirectors`.`ProgramDirectorsID`='".$mysqli->real_escape_string($_REQUEST['pd'])."')";
$result_data = $mysqli->query($qry) or die($mysqli->error.' '.$qry);
if($result_data->num_rows>0){
$result_data_array=$result_data->fetch_assoc();
$to = $result_data_array['EmailAddress'];
$subject = "Parts Ordering:: Your profile has been Updated";//Program Director
//CustomerServiceNow@TekkiesU.com
$password=generate_password();
$message = "
<html>
<head><title>SECHRIST INDUSTRIES,INC.</title></head>
<body>
<p>An administrative from the Customer Service have updated your profile details. <br><br>Your newly generated password is <u style='border:1px solid gray;background-color:gray;color:#FFF'>".$password."</u><br><br> If you have additional questions or concerns regarding account please call or email Customer Service at (714) 555-1212 and CustomerServiceNow@TekkiesU.com</p>
<table style='border-collapse: collapse;'><tr style='background-color: #DEE0EC;'></tr></table>
<p><a href='".SITE_PATH."'>Click here</a> to visit your dashboard.</p>
</body>
</html>
";//Program Director
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: <DoNotReply@SechristIndustries.com>' . "\r\n";
$headers .= 'Bcc: WebSiteOrders@Sechristusa.com' . "\r\n";
if(mail($to,$subject,$message,$headers)){
$mail_info_sent=true;
//update query- activate program director and save added details in the database
$updateQuery = "UPDATE `tblprogramdirectors` SET
`Password`='".$mysqli->real_escape_string($password)."'
WHERE `ProgramDirectorsID`=".$_REQUEST['pd'].";";
$mysqli->query($updateQuery);//run created query to feed data into mysql database
}//Program Director
}
}
//fetch data for the program directors
$qry="SELECT * FROM `tblprogramdirectors` WHERE EEStatus='A' ORDER BY BlueBookCode";
$result_data = $mysqli->query($qry) or die($mysqli->error.' '.$qry);
if($result_data->num_rows<=0){$msg='No matched items in the database!!!';$items='NOT_FOUND';}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title> Parts Ordering:: UnProcessed SITE-ID </title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="css/smart-forms.css">
<link rel="stylesheet" type="text/css" href="css/font-awesome.min.css">
<link rel="stylesheet" type="text/css" href="css/as.css">
<!--[if lte IE 9]>
<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>
<script type="text/javascript" src="js/jquery.placeholder.min.js"></script>
<![endif]-->
<!--[if lte IE 8]>
<link type="text/css" rel="stylesheet" href="css/smart-forms-ie8.css">
<![endif]-->
<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="js/plugins.js" type="text/javascript"></script>
<script src="js/scripts.js" type="text/javascript"></script>
<!-- Magnific Popup core CSS file -->
<link rel="stylesheet" href="css/magnific-popup.css" />
<!-- Magnific Popup core JS file -->
<script src="js/jquery.magnific-popup.min.js"></script>
<style>table#pd-table thead th, table#pd-table tbody td {padding: 0.5em 0.4em .5em .4em;}.smart-forms .form-body {min-height: 500px;}#menu ul{right:10px!important;}#menu ul li a{padding:15px 5px 20px 10px!important;}/*.edit-pencil-square{background-image: url('images/edit.png');height: 45px;width: 54px;}*/</style>
</head>
<body class="woodbg">
<?php if($mail_info_sent==true){ ?>
<div id="test-popup" class="white-popup mfp-hide">
An email has been sent to the Program Director with Following content.<br /><br /><?php echo $message;?>
</div>
<a href="#test-popup" class="open-popup-link" style="display: none;">Show inline popup</a>
<script type="text/javascript">
$(document).ready(function() {
$('.open-popup-link').magnificPopup({type:'inline'});
$('.open-popup-link').trigger('click');
});
</script>
<?php } ?>
<div class="smart-wrap">
<div class="smart-forms smart-container wrap-2">
<div class="form-header header-primary" id="menu">
<h4><i class="fa fa-flask"></i><a href="index.php" class="site-title">Parts Ordering</a>:: Customer Service</h4>
<a class="toggle" href="#"><i class="fa fa-bars"></i>Menu</a>
<ul id="menuse">
<li><a href="parts.php" class="">Parts List</a></li>
<li><a href="unprocessed-site-id.php" class="">UnProcessed SITE-ID</a></li>
<li><a href="approved-program-director.php" class="">Program Directors</a></li>
<li><a href="unprocessed-orders.php" class="">UnProcessed Orders</a></li>
<li><a href="approved-orders.php" class="">Approved Orders</a></li>
<li><a href="#" onclick="$('#logoutForm').submit();" class="">Logout</a><form action="index.php" class="hidden" method="POST" id="logoutForm"><input type="hidden" name="logout" value="true" /></form></li>
</ul>
</div><!-- end .form-header section -->
<div class="form-body">
<div class="spacer-t40 spacer-b40">
<div class="tagline"><span>::Approved Program Directors </span></div><!-- .tagline -->
</div>
<div class="frm-row">
<?php
if($items!='NOT_FOUND'){
?>
<table id="pd-table">
<thead><tr><th>First Name</th><th>Title</th><th>Facility Name</th><th>Email Address</th><th>Phone Number</th><th>Blue Book Code</th><!--<th>Address</th>--><th>Controls</th></tr></thead>
<?php while($item=$result_data->fetch_assoc()){
$address='';$name='';
/*
$address[]=$item['CompanyAddress1'];
if($item['CompanyAddress2']):
$address[]=$item['CompanyAddress2'];
endif;
$address[]=$item['City'];
$address[]=$item['State'];
$address[]=$item['Zip'];
$address[]=$item['Country'];
*/
//name
$name[]=$item['FirstName'];
$name[]=$item['LastName'];
?>
<tr>
<td><?php echo implode(' ',$name);?></td>
<td><?php echo $item['Title'];?></td>
<td><?php echo $item['FacilityName'];?></td>
<td><?php echo $item['EmailAddress'];?></td>
<td><?php echo $item['PhoneNumber'];?></td>
<td><?php echo $item['BlueBookCode'];?></td>
<!--<td><?php echo implode(',',$address);?></td>-->
<td><a title="Edit" href="edit-program-director.php?pd=<?php echo $item['ProgramDirectorsID'];?>"><i class="icon-edit"></i></a></td>
</tr>
<?php } ?>
</table>
<?php } ?>
</div><!-- end .frm-row section -->
</div><!-- end .form-body section -->
<div class="form-footer">
</div><!-- end .form-footer section -->
</div><!-- end .smart-forms section -->
</div><!-- end .smart-wrap section -->
<div></div><!-- end section -->
<!-- related script-->
<script src="js/pd-s.js" type="text/javascript"></script>
</body>
</html>