· 10 years ago · Jul 01, 2016, 05:45 PM
1<!DOCTYPE html>
2<html lang="en">
3
4<head>
5
6 <meta charset="utf-8">
7 <meta http-equiv="X-UA-Compatible" content="IE=edge">
8 <meta name="viewport" content="width=device-width, initial-scale=1">
9 <meta name="description" content="">
10 <meta name="author" content="">
11
12 <title>Sales Portal</title>
13
14 <!-- Bootstrap Core CSS -->
15 <link href="../bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
16
17 <!-- MetisMenu CSS -->
18 <link href="../bower_components/metisMenu/dist/metisMenu.min.css" rel="stylesheet">
19
20 <!-- Custom CSS -->
21 <link href="../dist/css/sb-admin-2.css" rel="stylesheet">
22
23 <!-- Custom Fonts -->
24 <link href="../bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
25 <link href="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/themes/smoothness/jquery-ui.css">
26 <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
27 <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
28 <!--[if lt IE 9]>
29 <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
30 <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
31 <![endif]-->
32
33 <script>
34 // This is an old version, for a more recent version look at
35 // https://jsfiddle.net/DRSDavidSoft/zb4ft1qq/2/
36 function maxLengthCheck(object)
37 {
38 if (object.value.length > object.maxLength)
39 object.value = object.value.slice(0, object.maxLength)
40 }
41</script>
42<script>
43$(function() {
44 $( "#name1" ).autocomplete({
45 source: 'suggestproduct.php'
46 });
47});
48</script>
49
50<script type="text/javascript">
51$(document).ready(function(){
52 $('#name1').on('change',function(){
53 var pr = $(this).val();
54 if(pr){
55 $('#price').attr('value',0);
56 $.ajax({
57 type:'POST',
58 url:'ajaxData.php',
59 data:'pr='+pr,
60 success:function(html){
61 $('#price').html(html);
62 }
63 });
64 }else{
65 $('#price').val(0);
66 }
67 });
68</script>
69
70
71</head>
72
73<body>
74
75 <div id="wrapper">
76
77 <!-- Navigation -->
78 <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0">
79 <div class="navbar-header">
80 <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
81 <span class="sr-only">Toggle navigation</span>
82 <span class="icon-bar"></span>
83 <span class="icon-bar"></span>
84 <span class="icon-bar"></span>
85 </button>
86 <a class="navbar-brand" href="index.html">UnivFranchisee</a>
87 </div>
88 <!-- /.navbar-header -->
89
90 <ul class="nav navbar-top-links navbar-right">
91
92 <!-- /.dropdown -->
93 <li class="dropdown">
94 <a class="dropdown-toggle" data-toggle="dropdown" href="#">
95 <i class="fa fa-bell fa-fw"></i> <i class="fa fa-caret-down"></i>
96 </a>
97 <ul class="dropdown-menu dropdown-alerts">
98 <li>
99 <a href="#">
100 <div>
101 <i class="fa fa-comment fa-fw"></i> New Comment
102 <span class="pull-right text-muted small">4 minutes ago</span>
103 </div>
104 </a>
105 </li>
106 <li class="divider"></li>
107 <li>
108 <a href="#">
109 <div>
110 <i class="fa fa-twitter fa-fw"></i> 3 New Followers
111 <span class="pull-right text-muted small">12 minutes ago</span>
112 </div>
113 </a>
114 </li>
115 <li class="divider"></li>
116 <li>
117 <a href="#">
118 <div>
119 <i class="fa fa-envelope fa-fw"></i> Message Sent
120 <span class="pull-right text-muted small">4 minutes ago</span>
121 </div>
122 </a>
123 </li>
124 <li class="divider"></li>
125 <li>
126 <a href="#">
127 <div>
128 <i class="fa fa-tasks fa-fw"></i> New Task
129 <span class="pull-right text-muted small">4 minutes ago</span>
130 </div>
131 </a>
132 </li>
133 <li class="divider"></li>
134 <li>
135 <a href="#">
136 <div>
137 <i class="fa fa-upload fa-fw"></i> Server Rebooted
138 <span class="pull-right text-muted small">4 minutes ago</span>
139 </div>
140 </a>
141 </li>
142 <li class="divider"></li>
143 <li>
144 <a class="text-center" href="#">
145 <strong>See All Alerts</strong>
146 <i class="fa fa-angle-right"></i>
147 </a>
148 </li>
149 </ul>
150 <!-- /.dropdown-alerts -->
151 </li>
152 <!-- /.dropdown -->
153 <li class="dropdown">
154 <a class="dropdown-toggle" data-toggle="dropdown" href="#">
155 <i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i>
156 </a>
157 <ul class="dropdown-menu dropdown-user">
158 <li><a href="#"><i class="fa fa-user fa-fw"></i> User Profile</a>
159 </li>
160 <li><a href="#"><i class="fa fa-gear fa-fw"></i> Settings</a>
161 </li>
162 <li class="divider"></li>
163 <li><a href="login.html"><i class="fa fa-sign-out fa-fw"></i> Logout</a>
164 </li>
165 </ul>
166 <!-- /.dropdown-user -->
167 </li>
168 <!-- /.dropdown -->
169 </ul>
170 <!-- /.navbar-top-links -->
171
172 <div class="navbar-default sidebar" role="navigation">
173 <div class="sidebar-nav navbar-collapse">
174 <ul class="nav" id="side-menu">
175 <li class="sidebar-search">
176 <div class="input-group custom-search-form">
177 <input type="text" class="form-control" placeholder="Search...">
178 <span class="input-group-btn">
179 <button class="btn btn-default" type="button">
180 <i class="fa fa-search"></i>
181 </button>
182 </span>
183 </div>
184 <!-- /input-group -->
185 </li>
186 <li>
187 <a href="#"><i class="fa fa-dashboard fa-fw"></i> Master<span class="fa arrow"></span></a>
188 <ul class="nav nav-second-level">
189 <li>
190 <a href="unit_master.html"> Unit Master</a>
191 </li>
192 <li>
193 <a href="ctype.html"> Card Type</a>
194 </li>
195 <li>
196 <a href="#">Card Master</a>
197 </li>
198 <li>
199 <a href="#">Activate Card</a>
200 </li>
201 <li>
202 <a href="#">Value Card Recharge Req.</a>
203 </li>
204 <li>
205 <a href="#">Car Segment</a>
206 </li>
207 <li>
208 <a href="#">Service Master</a>
209 </li>
210 <li>
211 <a href="#">Discount Master</a>
212 </li>
213 <li>
214 <a href="#">Product Category Master</a>
215 </li>
216 <li>
217 <a href="#">Product Master</a>
218 </li>
219 <li>
220 <a href="#">Rate Master</a>
221 </li>
222 <li>
223 <a href="#">Download Master</a>
224 </li>
225 <li>
226 <a href="#">Stock Master</a>
227 </li>
228 <li>
229 <a href="#">Vendor Master</a>
230 </li>
231 <li>
232 <a href="#">Purchase Entry</a>
233 </li>
234 <li>
235 <a href="#">Branch Office Master</a>
236 </li>
237 <li>
238 <a href="#">Create User</a>
239 </li>
240 </ul>
241 </li>
242
243 <li>
244 <a href="#"><i class="fa fa-sitemap fa-fw"></i> Franchize<span class="fa arrow"></span></a>
245 <ul class="nav nav-second-level">
246 <li>
247 <a href="#">Create Franchisee</a>
248 </li>
249 <li>
250 <a href="#">Manage Royality</a>
251 </li>
252 <li>
253 <a href="#">Manage BM Calls</a>
254 </li>
255 </ul>
256 <!-- /.nav-second-level -->
257 </li>
258 <li>
259 <a href="#"><i class="fa fa-wrench fa-fw"></i> Application<span class="fa arrow"></span></a>
260 <ul class="nav nav-second-level">
261 <li>
262 <a href="#">Latest News & Events</a>
263 </li>
264 <li>
265 <a href="#">Target Vs. Acheivement</a>
266 </li>
267 <li>
268 <a href="#">Schemes And Offers</a>
269 </li>
270 <li>
271 <a href="#">Change Password</a>
272 </li>
273 </ul>
274 <!-- /.nav-second-level -->
275 </li>
276 <li>
277 <a href="#"><i class="fa fa-files-o fa-fw"></i> Admin Sale<span class="fa arrow"></span></a>
278 <ul class="nav nav-second-level">
279 <li>
280 <a href="#">Purchase Request</a>
281 </li>
282 <li>
283 <a href="#">Balance Amount</a>
284 </li>
285 <li>
286 <a href="#">Proposal Invoice</a>
287 </li>
288 <li>
289 <a href="#">Sale WithOut PO</a>
290 </li>
291 </ul>
292 <!-- /.nav-second-level -->
293 </li>
294 <li>
295 <a href="#"><i class="fa fa-bar-chart-o fa-fw"></i> Report<span class="fa arrow"></span></a>
296 <ul class="nav nav-second-level">
297 <li>
298 <a href="#">Stock Report</a>
299 </li>
300 <li>
301 <a href="#">Value Card Report</a>
302 </li>
303 <li>
304 <a href="#">Service Report</a>
305 </li>
306 <li>
307 <a href="#">Proposal Invoice Report</a>
308 </li>
309 <li>
310 <a href="#">Admin Sale Report</a>
311 </li>
312 <li>
313 <a href="#">Franchise Sale Report</a>
314 </li>
315 <li>
316 <a href="#">Job Card Report</a>
317 </li>
318 <li>
319 <a href="#">Royalty Reports</a>
320 </li>
321 <li>
322 <a href="#">Target Vs Achievment Reports</a>
323 </li>
324 </ul>
325 <!-- /.nav-second-level -->
326 </li>
327 <li>
328 <a href="#"><i class="fa fa-files-o fa-fw"></i> Help</a>
329 <ul class="nav nav-second-level">
330 </ul>
331 <!-- /.nav-second-level -->
332 </li>
333 </ul>
334 </div>
335 <!-- /.sidebar-collapse -->
336 </div>
337 <!-- /.navbar-static-side -->
338 </nav>
339
340 <div id="page-wrapper">
341 <div class="row">
342 <div class="col-lg-12">
343 <h1 class="page-header">Sales Portal</h1>
344 </div>
345 <!-- /.col-lg-12 -->
346 </div>
347 <!-- /.row -->
348 <div class="row">
349 <div class="col-lg-12">
350 <div class="panel panel-default">
351 <div class="panel-heading">
352 Fields marked with <span style="color: red">*</span> are compulsory.</div>
353 <div class="panel-body">
354 <div class="row">
355 <form method='POST' action='createfr.php'>
356 <div class="col-lg-6">
357
358 <div class="form-group">
359 <label>Product Name</label>
360 <span style="color: red">*</span>
361 <input name="name1" id='name1' required class="form-control">
362 </div>
363 </div>
364 <!-- /.col-lg-6 (nested) -->
365 <div class="col-lg-6">
366
367 <div class="form-group">
368 <label>Customer Name</label>
369 <span style="color: red">*</span>
370 <input name="cname" required class="form-control">
371 </div>
372 </div>
373
374 <div class="col-lg-6">
375 <div class="form-group">
376 <label>Mobile Number</label>
377 <span style="color: red">*</span>
378 <input type="number" maxlength="10" oninput="maxLengthCheck(this)" name="num1" required class="form-control">
379 </div>
380 </div>
381 <div class="col-lg-6">
382 <div class="form-group">
383 <label>Email ID</label>
384 <input type="email" name="eid1" class="form-control">
385 </div>
386 </div>
387 <div class="col-lg-6">
388 <div class="form-group">
389 <label>Purchase Date</label>
390<input name="pdate" class="form-control" type="date" Disabled value="<?php echo date('Y-m-d'); ?>">
391 </div>
392 </div>
393 <div class="col-lg-6">
394 <div class="form-group">
395 <label>Price</label>
396 <span style="color: red">*</span>
397 <input type="number" name="price" id='price'class="form-control">
398 </div>
399 </div>
400
401
402 <!-- /.col-lg-6 (nested) -->
403 </div>
404 <div class="row text-center">
405 <button name="submit" type="submit" class="btn btn-default">Submit</button>
406 <button type="reset" class="btn btn-default">Clear</button>
407 </div>
408 </form>
409<?php
410if(isset($_POST["submit"]))
411{
412 $data1=$_POST["name1"];
413 $data6=$_POST["num1"];
414 $data7=$_POST["eid1"];
415 $data12=$_POST["pdate"];
416
417 // DATABASE Details SET server user and password
418
419$servername='localhost'; $username='root'; $password='';
420$dbname='franchisee'; $tbname='sales';
421
422 // Create connection
423$conn = mysqli_connect($servername, $username, $password);
424
425// Check connection
426if (!$conn) {
427 die("Connection failed: " . mysqli_connect_error());
428}
429
430
431$sql = "INSERT INTO $tbname (name,uid,pass,cname,addr,mob,email,cst,stax,vat,rlty,sdate,edate)
432VALUES ('$data1','$data2','$data3','$data4','$data5',$data6,'$data7',$data8,$data9,$data10,$data11,'$data12','$data13')";
433
434 //Create DB
435if(!mysqli_query($conn,"CREATE DATABASE IF NOT EXISTS $dbname")){echo "Error Creating DB : " . $sql . "<br>" . mysqli_error($conn);}
436
437//Create Table
438if(!mysqli_query($conn,"CREATE TABLE IF NOT EXISTS `$dbname`.`$tbname` (id int(11) NOT NULL UNIQUE AUTO_INCREMENT,name varchar(25),uid varchar(20) PRIMARY KEY,mob int(15),email varchar(50),pdate date)")){echo "Error Creating Table : " . $sql . "<br>" . mysqli_error($conn);}
439
440//Select DB
441mysqli_select_db($conn, $dbname);
442
443if (mysqli_query($conn, $sql)) {
444 echo "<br/><h3>User: ".$data2." added successfully</h3><br/>";
445} else {
446 echo "Error: " . $sql . "<br>" . mysqli_error($conn);
447}
448}
449?>
450
451 <!-- /.row (nested) -->
452 </div>
453 <!-- /.panel-body -->
454
455 </div>
456 <!-- /.panel -->
457
458 </div>
459 <!-- /.col-lg-12 -->
460 </div>
461 <!-- /.row -->
462 </div>
463 <!-- /#page-wrapper -->
464
465 </div>
466 <!-- /#wrapper -->
467
468 <!-- jQuery -->
469 <script src="../bower_components/jquery/dist/jquery.min.js"></script>
470
471 <!-- Bootstrap Core JavaScript -->
472 <script src="../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
473
474 <!-- Metis Menu Plugin JavaScript -->
475 <script src="../bower_components/metisMenu/dist/metisMenu.min.js"></script>
476
477 <!-- Custom Theme JavaScript -->
478 <script src="../dist/js/sb-admin-2.js"></script>
479
480 <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/i18n/jquery-ui-i18n.js"></script>
481
482 <script src=""></script>
483
484
485
486</body>
487
488</html>