Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <section class="content-header">
- <h1>
- <?php echo ucfirst($page) ; ?>
- <small>Panel</small>
- </h1>
- <ol class="breadcrumb">
- <li><a href="./"><i class="fa fa-dashboard"></i> Home</a></li>
- <li><a href="?page=<?php echo $page ?>"><?php echo ucfirst($page) ; ?></a></li>
- <li class="active"><?php echo ucfirst($action) ; ?> Data</li>
- </ol>
- </section>
- <section class="content">
- <!-- Horizontal Form -->
- <div class="box box-info">
- <div class="box-header with-border">
- <h3 class="box-title"><?php echo ucfirst($page) ; ?> Form</h3>
- </div><!-- /.box-header -->
- <!-- form start -->
- <?php
- include "inc/config.php";
- // membaca id transaksi terbesar
- $carikode = mysql_query("SELECT max(no_urut) as no_user FROM t_prospek") or die(mysql_error());
- $datakode = mysql_fetch_array($carikode);
- $kodeuser = $datakode['no_user'];
- // mengambil angka atau bilangan dalam id transaksi terbesar,
- // dengan cara mengambil substring mulai dari karakter ke-1 diambil 6 karakter
- // misal 'INV001', akan diambil '001'
- // setelah substring bilangan diambil lantas dicasting menjadi integer
- $noUrut = (int) substr($kodeuser, 3, 3);
- // bilangan yang diambil ini ditambah 1 untuk menentukan nomor urut berikutnya
- $noUrut++;
- // membentuk id transaksi baru
- // perintah sprintf("%03s", $noUrut); digunakan untuk memformat string sebanyak 3 karakter
- // misal sprintf("%03s", 12); maka akan dihasilkan '012'
- // atau misal sprintf("%03s", 1); maka akan dihasilkan string '001'
- $char = "MOC";
- $newID = $char . sprintf("%03s",$noUrut);
- /*
- NO INVOICE
- */
- // membaca id transaksi terbesar
- $cariinvoice = mysql_query("SELECT max(no_invoice) as no_tagihan FROM t_prospek") or die(mysql_error());
- $datainvoice = mysql_fetch_array($cariinvoice);
- $kodetagihan = $datainvoice['no_tagihan'];
- // mengambil angka atau bilangan dalam id transaksi terbesar,
- // dengan cara mengambil substring mulai dari karakter ke-1 diambil 6 karakter
- // misal 'INV001', akan diambil '001'
- // setelah substring bilangan diambil lantas dicasting menjadi integer
- $noTagihan = (int) substr($kodetagihan, 3, 3);
- // bilangan yang diambil ini ditambah 1 untuk menentukan nomor urut berikutnya
- $noTagihan++;
- // membentuk id transaksi baru
- // perintah sprintf("%03s", $noUrut); digunakan untuk memformat string sebanyak 3 karakter
- // misal sprintf("%03s", 12); maka akan dihasilkan '012'
- // atau misal sprintf("%03s", 1); maka akan dihasilkan string '001'
- $char_invoice = "INV";
- $newID_Invoice = $char_invoice . sprintf("%03s",$noTagihan);
- ?>
- <form class="form-horizontal" method="POST" action="" enctype="multipart/form-data">
- <div class="box-body">
- <div hidden class="form-group">
- <label for="inputEmail3" class="col-sm-3 control-label">No Urut</label>
- <div class="col-sm-5">
- <input type="text" name="no_urut" readonly value="<?php echo $newID ?>" class="form-control" placeholder="No Urut">
- </div>
- </div>
- <div class="form-group">
- <label for="inputEmail3" class="col-sm-3 control-label">No Invoice</label>
- <div class="col-sm-5">
- <input type="text" name="no_invoice" readonly value="<?php echo $newID_Invoice ?>" class="form-control" placeholder="No Urut">
- </div>
- </div>
- <div class="form-group">
- <label for="inputEmail3" class="col-sm-3 control-label">Nama</label>
- <div class="col-sm-5">
- <input type="text" name="nama" class="form-control" placeholder="Nama">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">PIN</label>
- <div class="col-sm-5">
- <input type="text" name="pin" class="form-control" placeholder="PIN">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Line</label>
- <div class="col-sm-5">
- <input type="text" name="line" class="form-control" placeholder="Line">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">No HP</label>
- <div class="col-sm-5">
- <input type="text" name="no_hp" class="form-control" maxlength="12" placeholder="No HP">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">WA</label>
- <div class="col-sm-5">
- <input type="text" name="wa" class="form-control" maxlength="12" placeholder="WA">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Email</label>
- <div class="col-sm-5">
- <input type="email" name="email" class="form-control" placeholder="Email">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Asal Kota</label>
- <div class="col-sm-5">
- <input type="text" name="kota" class="form-control" placeholder="Asal Kota">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Produk</label>
- <div class="col-sm-5">
- <!--<textarea name="produk" class="form-control" cols="20" rows="10"></textarea>-->
- <input type="text" name="produk" class="form-control" placeholder="Produk">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Kategori Produk</label>
- <div class="col-sm-5">
- <select name="kategori" required class="form-control">
- <option value="">Pilih Kategori</option>
- <?php
- include "inc/config.php";
- $pos=mysql_query("SELECT * from t_kategori order by id");
- while($r_pos=mysql_fetch_array($pos)){
- echo "<option value=\"$r_pos[id]\">$r_pos[nama_kategori]</option>";
- }
- ?>
- </select>
- </div>
- <div class="col-sm-4">
- <a href="?page=kategori&aksi=tambah" class="btn btn-primary btn-flat" title="Tambah Kategori"><i class="fa fa-plus-circle"></i></a>
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Facebook</label>
- <div class="col-sm-5">
- <input type="text" name="fb" class="form-control" placeholder="Facebook">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Twitter</label>
- <div class="col-sm-5">
- <input type="text" name="twitter" class="form-control" placeholder="Twitter">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Instagram</label>
- <div class="col-sm-5">
- <input type="text" name="instagram" class="form-control" placeholder="Instagram">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Web</label>
- <div class="col-sm-5">
- <input type="text" name="web" class="form-control" placeholder="Web">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Nama Karyawan</label>
- <div class="col-sm-5">
- <select name="karyawan" required class="form-control">
- <option value="">Pilih Karyawan</option>
- <?php
- include "inc/config.php";
- $pos_kar=mysql_query("SELECT * from t_karyawan order by id");
- while($r_pos_kar=mysql_fetch_array($pos_kar)){
- if(mysql_num_rows($r_pos_kar) > 0){
- echo "<option value=\"\">Tidak Ada Data</option>";
- }else{
- echo "<option value=\"$r_pos_kar[id]\">$r_pos_kar[nip] - $r_pos_kar[nama]</option>";
- //<option value="">Tidak Ada Data</option>
- }
- }
- ?>
- </select>
- </div>
- <div class="col-sm-4">
- <a href="?page=karyawan&aksi=tambah" class="btn btn-primary btn-flat" title="Tambah Karyawan"><i class="fa fa-plus-circle"></i></a>
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Pernah menjadi konsumen?</label>
- <div class="col-sm-5">
- <div class="checkbox">
- <label>
- <input type="checkbox" name="j_konsumen[]" id="checkaplikasi" value="aplikasi"> Aplikasi
- <br/>
- <div id="aplikasi" hidden>
- <div class="box box-success box-solid">
- <div class="box-header with-border">
- <h3 class="box-title">Detail Data Aplikasi</h3>
- </div><!-- /.box-header -->
- <div class="box-body">
- <div class="box-body">
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Nama Aplikasi</label>
- <div class="col-sm-8">
- <input type="text" name="nm_aplikasi" class="form-control" placeholder="Nama Aplikasi">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Domain</label>
- <div class="col-sm-8">
- <input type="text" name="domain" class="form-control" placeholder="Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Tgl Order</label>
- <div class="col-sm-8">
- <input type="text" name="tgl_order" id="tgl_order" class="form-control" data-date-format="yyyy-mm-dd" placeholder="Tgl Order">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Tgl Expired</label>
- <div class="col-sm-8">
- <input type="text" name="expired" id="expired" class="form-control" data-date-format="yyyy-mm-dd" placeholder="Tgl Expired">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Harga Paket</label>
- <div class="col-sm-8">
- <input type="text" name="harga_paket" maxlength="12" class="form-control" id="harga_paket" placeholder="Harga Paket">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Harga Perpanjangan</label>
- <div class="col-sm-8">
- <input type="text" name="perpanjangan" maxlength="12" class="form-control" id="harga_perpanjangan" placeholder="Harga Perpanjangan">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Tempat Hosting</label>
- <div class="col-sm-8">
- <input type="text" name="t_hosting" class="form-control" placeholder="Tempat Hosting">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Paket Hosting</label>
- <div class="col-sm-8">
- <input type="text" name="paket_hosting" class="form-control" placeholder="Paket Hosting">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Penyedia Domain</label>
- <div class="col-sm-8">
- <input type="text" name="penyedia_domain" class="form-control" placeholder="Penyedia Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">User Cpanel</label>
- <div class="col-sm-8">
- <input type="text" name="u_cpanel" class="form-control" placeholder="User Cpanel">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Password Cpanel</label>
- <div class="col-sm-8">
- <input type="text" name="pass_cpanel" class="form-control" placeholder="Password Cpanel">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">User Klien</label>
- <div class="col-sm-8">
- <input type="text" name="u_client" class="form-control" placeholder="User Klien">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Password Klien</label>
- <div class="col-sm-8">
- <input type="text" name="pass_client" class="form-control" placeholder="Password Klien">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">User Domain</label>
- <div class="col-sm-8">
- <input type="text" name="u_domain" class="form-control" placeholder="User Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Password Domain</label>
- <div class="col-sm-8">
- <input type="text" name="pass_domain" class="form-control" placeholder="Password Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Catatan</label>
- <div class="col-sm-8">
- <textarea name="catatan" class="form-control" cols="20" rows="10"></textarea>
- </div>
- </div>
- </div>
- </div><!-- /.box-body -->
- </div>
- </div>
- <input type="checkbox" name="j_konsumen[]" id="checkweb" value="web"> Web
- <br/>
- <div id="web" hidden>
- <div class="box box-success box-solid">
- <div class="box-header with-border">
- <h3 class="box-title">Detail Data Web</h3>
- </div><!-- /.box-header -->
- <div class="box-body">
- <div class="box-body">
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Nama Web</label>
- <div class="col-sm-8">
- <input type="text" name="nm_web" class="form-control" placeholder="Nama Web">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Domain</label>
- <div class="col-sm-8">
- <input type="text" name="domain_web" class="form-control" placeholder="Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Tgl Order</label>
- <div class="col-sm-8">
- <input type="text" name="tgl_order_web" id="tgl_order_web" class="form-control" data-date-format="yyyy-mm-dd" placeholder="Tgl Order">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Tgl Expired</label>
- <div class="col-sm-8">
- <input type="text" name="expired_web" id="expired_web" class="form-control" data-date-format="yyyy-mm-dd" placeholder="Tgl Expired">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Harga Paket</label>
- <div class="col-sm-8">
- <input type="text" name="harga_paket_web" maxlength="12" class="form-control" id="harga_paket_web" placeholder="Harga Perpanjangan">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Harga Perpanjangan</label>
- <div class="col-sm-8">
- <input type="text" name="perpanjangan_web" maxlength="12" class="form-control" id="perpanjangan_web" placeholder="Harga Perpanjangan">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Tempat Hosting</label>
- <div class="col-sm-8">
- <input type="text" name="t_hosting_web" class="form-control" placeholder="Tempat Hosting">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Paket Hosting</label>
- <div class="col-sm-8">
- <input type="text" name="paket_hosting_web" class="form-control" placeholder="Paket Hosting">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Penyedia Domain</label>
- <div class="col-sm-8">
- <input type="text" name="penyedia_domain_web" class="form-control" placeholder="Penyedia Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">User Cpanel</label>
- <div class="col-sm-8">
- <input type="text" name="u_cpanel_web" class="form-control" placeholder="User Cpanel">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Password Cpanel</label>
- <div class="col-sm-8">
- <input type="text" name="pass_cpanel_web" class="form-control" placeholder="Password Cpanel">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">User Klien</label>
- <div class="col-sm-8">
- <input type="text" name="u_client_web" class="form-control" placeholder="User Klien">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Password Klien</label>
- <div class="col-sm-8">
- <input type="text" name="pass_client_web" class="form-control" placeholder="Password Klien">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">User Domain</label>
- <div class="col-sm-8">
- <input type="text" name="u_domain_web" class="form-control" placeholder="User Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Password Domain</label>
- <div class="col-sm-8">
- <input type="text" name="pass_domain_web" class="form-control" placeholder="Password Domain">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Catatan</label>
- <div class="col-sm-8">
- <textarea name="catatan_web" class="form-control" cols="20" rows="10"></textarea>
- </div>
- </div>
- </div>
- </div><!-- /.box-body -->
- </div>
- </div>
- <input type="checkbox" name="j_konsumen[]" id="checkbot" value="bot"> Bot
- <br/>
- <div id="bot" hidden>
- <div class="box box-success box-solid">
- <div class="box-header with-border">
- <h3 class="box-title">Detail Data Bot</h3>
- </div><!-- /.box-header -->
- <div class="box-body">
- <div class="box-body">
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Nama Bot</label>
- <div class="col-sm-8">
- <input type="text" name="nm_bot" class="form-control" placeholder="Nama Bot">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Email</label>
- <div class="col-sm-8">
- <input type="email" name="email_bot" class="form-control" placeholder="Email">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Lisensi</label>
- <div class="col-sm-8">
- <input type="text" name="lisensi_bot" class="form-control" placeholder="Lisensi">
- </div>
- </div>
- </div>
- </div><!-- /.box-body -->
- </div>
- </div>
- <input type="checkbox" name="j_konsumen[]" id="checksos" value="sos"> SOS
- <br/>
- <div id="sos" hidden>
- <div class="box box-success box-solid">
- <div class="box-header with-border">
- <h3 class="box-title">Detail Data SOS</h3>
- </div><!-- /.box-header -->
- <div class="box-body">
- <div class="box-body">
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Email</label>
- <div class="col-sm-8">
- <input type="email" name="email_sos" class="form-control" placeholder="Email">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Jenis Member</label>
- <div class="col-sm-8">
- <input type="radio" name="j_member" value="free"> Free
- <input type="radio" name="j_member" value="premium"> Premium
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-4 control-label">Level</label>
- <div class="col-sm-8">
- <input type="radio" name="level_sos" class="minimal" value="beginner"> Beginner <br/>
- <input type="radio" name="level_sos" class="minimal" value="intermedite"> Intermedite <br/>
- <input type="radio" name="level_sos" class="minimal" value="advanced"> Advanced
- </div>
- </div>
- </div>
- </div><!-- /.box-body -->
- </div>
- </div>
- </label>
- </div>
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-3 control-label">Sudah di prospek?</label>
- <div class="col-sm-5">
- <div class="checkbox">
- <label>
- <input type="checkbox" name="j_prospek[]" value="sms"> SMS
- <br/>
- <input type="checkbox" name="j_prospek[]" value="line"> Line
- <br/>
- <input type="checkbox" name="j_prospek[]" value="pin"> PIN
- <br/>
- <input type="checkbox" name="j_prospek[]" value="fb"> FB
- <br/>
- <input type="checkbox" name="j_prospek[]" value="telepon"> Telepon
- </label>
- </div>
- </div>
- </div>
- </div><!-- /.box-body -->
- <div class="box-footer">
- <center>
- <a href="?page=<?php echo $page ?>" class="btn btn-warning btn-flat"><i class="fa fa-arrow-left"></i> Batal</a>
- <button type="submit" name="submit" class="btn btn-success btn-flat"><i class="fa fa-save"></i> Simpan</button>
- </center>
- </div><!-- /.box-footer -->
- </form>
- </div><!-- /.box -->
- </section><!-- /.content -->
- <?php
- include "inc/config.php";
- // Main Form
- $nama = @$_POST['nama'];
- $no_urut = @$_POST['no_urut'];
- $no_invoice = @$_POST['no_invoice'];
- $pin = @$_POST['pin'];
- $line = @$_POST['line'];
- $hp = @$_POST['no_hp'];
- $wa = @$_POST['wa'];
- $email = @$_POST['email'];
- $kota = @$_POST['kota'];
- $produk = @$_POST['produk'];
- $kategori = @$_POST['kategori'];
- $fb = @$_POST['fb'];
- $twitter = @$_POST['twitter'];
- $ig = @$_POST['instagram'];
- $web = @$_POST['web'];
- $j_konsumen = @implode(',',$_POST['j_konsumen']);
- $j_prospek = @implode(',',$_POST['j_prospek']);
- $nama_karyawan = @$_POST['karyawan'];
- // Form detail Aplikasi
- $nm_aplikasi = @$_POST['nm_aplikasi'];
- $domain = @$_POST['domain'];
- $tgl_order = @$_POST['tgl_order'];
- $expired = @$_POST['expired'];
- $harga_paket = @$_POST['harga_paket'];
- $perpanjangan = @$_POST['perpanjangan'];
- $t_hosting = @$_POST['t_hosting'];
- $paket_hosting = @$_POST['paket_hosting'];
- $u_cpanel = @$_POST['u_cpanel'];
- $penyedia_domain= @$_POST['penyedia_domain'];
- $pass_cpanel = @$_POST['pass_cpanel'];
- $u_client = @$_POST['u_client'];
- $pass_client = @$_POST['pass_client'];
- $u_domain = @$_POST['u_domain'];
- $pass_domain = @$_POST['pass_domain'];
- $catatan = @$_POST['catatan'];
- // Form detail Web
- $nm_web = @$_POST['nm_web'];
- $domain_web = @$_POST['domain_web'];
- $tgl_order_web= @$_POST['tgl_order_web'];
- $expired_web = @$_POST['expired_web'];
- $harga_paket_web = @$_POST['harga_paket_web'];
- $perpanjangan_web = @$_POST['perpanjangan_web'];
- $t_hosting_web = @$_POST['t_hosting_web'];
- $paket_hosting_web = @$_POST['paket_hosting_web'];
- $penyedia_domain_web = @$_POST['penyedia_domain_web'];
- $u_cpanel_web = @$_POST['u_cpanel_web'];
- $pass_cpanel_web = @$_POST['pass_cpanel_web'];
- $u_client_web = @$_POST['u_client_web'];
- $pass_client_web = @$_POST['pass_client_web'];
- $u_domain_web = @$_POST['u_domain_web'];
- $pass_domain_web = @$_POST['pass_domain_web'];
- $catatan_web = @$_POST['catatan_web'];
- // Form detail Bot
- $nm_bot = @$_POST['nm_bot'];
- $email_bot = @$_POST['email_bot'];
- $lisensi_bot = @$_POST['lisensi_bot'];
- // Form detail SOS
- $email_sos = @$_POST['email_sos'];
- $j_member = @$_POST['j_member'];
- $level_sos = @$_POST['level_sos'];
- if (isset($_POST['submit'])) {
- if(isset($_POST['j_konsumen'])){
- $konsumen = 'Ya';
- }else{
- $konsumen = 'Tidak';
- }
- if(isset($_POST['j_prospek'])){
- $prospek = 'Ya';
- }else{
- $prospek = 'Tidak';
- }
- /* Cek Data PIN */
- $cek_pin = mysql_num_rows(mysql_query("SELECT pin FROM t_prospek WHERE pin = '$pin' "));
- /* Cek Data PIN */
- $cek_web = mysql_num_rows(mysql_query("SELECT web FROM t_prospek WHERE web = '$web' "));
- /* Cek Data No HP */
- $cek_nope = mysql_num_rows(mysql_query("SELECT no_hp FROM t_prospek WHERE no_hp = '$no_hp' "));
- /* Cek Data Email */
- $cek_email = mysql_num_rows(mysql_query("SELECT email FROM t_prospek WHERE email = '$email' "));
- // Cek no PIN
- if($cek_pin > 0){
- echo "<script type='text/javascript'>alert('maaf data pin sudah ada');</script>";
- }else{
- /* Insert t_prospek */
- mysql_query("INSERT INTO t_prospek (no_urut, no_invoice, nama, pin, line , no_hp, wa, email, asal_kota, produk, kat_produk, fb, twitter, ig, web, nama_karyawan, konsumen, j_konsumen, prospek, j_prospek, tgl_input, waktu_input, user_id) values ('$no_urut', '$no_invoice', '$nama', '$pin', '$line', '$hp', '$wa', '$email', '$kota', '$produk', '$kategori', '$fb', '$twitter', '$ig', '$web', '$nama_karyawan', '$konsumen', '$j_konsumen', '$prospek', '$j_prospek', NOW(), NOW(), '$_SESSION[userid]')") or die (mysql_error());
- /* Insert t_aplikasi */
- mysql_query("INSERT INTO t_aplikasi (nama_aplikasi, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_aplikasi', '$domain', '$tgl_order', '$expired','".str_replace(".","",$harga_paket)."','".str_replace(".","",$harga_perpanjangan)."', '$t_hosting', '$paket_hosting', '$penyedia_domain', '$u_cpanel', '$pass_cpanel', '$u_client', '$pass_client', '$u_domain', '$pass_domain', '$no_urut', '$catatan')") or die(mysql_error());
- /* Insert t_web */
- mysql_query("INSERT INTO t_web (nama_web, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_web', '$domain_web', '$tgl_order_web', '$expired_web','".str_replace(".","",$harga_paket_web)."','".str_replace(".","",$perpanjangan_web)."', '$t_hosting_web', '$paket_hosting_web', '$penyedia_domain_web', '$u_cpanel_web', '$pass_cpanel_web', '$u_client_web', '$pass_client_web', '$u_domain_web', '$pass_domain_web', '$no_urut','$catatan_web')") or die(mysql_error());
- /* Insert t_bot */
- mysql_query("INSERT INTO t_bot (nm_bot, email, lisensi, id_prospek) values ('$nm_bot', '$email_bot', '$lisensi_bot', '$no_urut')") or die(mysql_error());
- /* Insert t_sos */
- mysql_query("INSERT INTO t_sos (email, j_member, level_sos, id_prospek) values ('$email_sos', '$j_member', '$level_sos', '$no_urut')") or die(mysql_error());
- echo '<META HTTP-EQUIV="Refresh" Content="0; URL=?page=prospek">';
- }
- //Cek Web
- if($cek_web > 0){
- echo "<script type='text/javascript'>alert('maaf data web sudah ada');</script>";
- }else{
- /* Insert t_prospek */
- mysql_query("INSERT INTO t_prospek (no_urut, no_invoice, nama, pin, line , no_hp, wa, email, asal_kota, produk, kat_produk, fb, twitter, ig, web, nama_karyawan, konsumen, j_konsumen, prospek, j_prospek, tgl_input, waktu_input, user_id) values ('$no_urut', '$no_invoice', '$nama', '$pin', '$line', '$hp', '$wa', '$email', '$kota', '$produk', '$kategori', '$fb', '$twitter', '$ig', '$web', '$nama_karyawan', '$konsumen', '$j_konsumen', '$prospek', '$j_prospek', NOW(), NOW(), '$_SESSION[userid]')") or die (mysql_error());
- /* Insert t_aplikasi */
- mysql_query("INSERT INTO t_aplikasi (nama_aplikasi, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_aplikasi', '$domain', '$tgl_order', '$expired','".str_replace(".","",$harga_paket)."','".str_replace(".","",$harga_perpanjangan)."', '$t_hosting', '$paket_hosting', '$penyedia_domain', '$u_cpanel', '$pass_cpanel', '$u_client', '$pass_client', '$u_domain', '$pass_domain', '$no_urut', '$catatan')") or die(mysql_error());
- /* Insert t_web */
- mysql_query("INSERT INTO t_web (nama_web, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_web', '$domain_web', '$tgl_order_web', '$expired_web','".str_replace(".","",$harga_paket_web)."','".str_replace(".","",$perpanjangan_web)."', '$t_hosting_web', '$paket_hosting_web', '$penyedia_domain_web', '$u_cpanel_web', '$pass_cpanel_web', '$u_client_web', '$pass_client_web', '$u_domain_web', '$pass_domain_web', '$no_urut','$catatan_web')") or die(mysql_error());
- /* Insert t_bot */
- mysql_query("INSERT INTO t_bot (nm_bot, email, lisensi, id_prospek) values ('$nm_bot', '$email_bot', '$lisensi_bot', '$no_urut')") or die(mysql_error());
- /* Insert t_sos */
- mysql_query("INSERT INTO t_sos (email, j_member, level_sos, id_prospek) values ('$email_sos', '$j_member', '$level_sos', '$no_urut')") or die(mysql_error());
- echo '<META HTTP-EQUIV="Refresh" Content="0; URL=?page=prospek">';
- }
- // Cek no HP
- if($cek_nope > 0){
- echo "<script type='text/javascript'>alert('maaf data no HP sudah ada');</script>";
- }else{
- /* Insert t_prospek */
- mysql_query("INSERT INTO t_prospek (no_urut, no_invoice, nama, pin, line , no_hp, wa, email, asal_kota, produk, kat_produk, fb, twitter, ig, web, nama_karyawan, konsumen, j_konsumen, prospek, j_prospek, tgl_input, waktu_input, user_id) values ('$no_urut', '$no_invoice', '$nama', '$pin', '$line', '$hp', '$wa', '$email', '$kota', '$produk', '$kategori', '$fb', '$twitter', '$ig', '$web', '$nama_karyawan', '$konsumen', '$j_konsumen', '$prospek', '$j_prospek', NOW(), NOW(), '$_SESSION[userid]')") or die (mysql_error());
- /* Insert t_aplikasi */
- mysql_query("INSERT INTO t_aplikasi (nama_aplikasi, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_aplikasi', '$domain', '$tgl_order', '$expired','".str_replace(".","",$harga_paket)."','".str_replace(".","",$harga_perpanjangan)."', '$t_hosting', '$paket_hosting', '$penyedia_domain', '$u_cpanel', '$pass_cpanel', '$u_client', '$pass_client', '$u_domain', '$pass_domain', '$no_urut', '$catatan')") or die(mysql_error());
- /* Insert t_web */
- mysql_query("INSERT INTO t_web (nama_web, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_web', '$domain_web', '$tgl_order_web', '$expired_web','".str_replace(".","",$harga_paket_web)."','".str_replace(".","",$perpanjangan_web)."', '$t_hosting_web', '$paket_hosting_web', '$penyedia_domain_web', '$u_cpanel_web', '$pass_cpanel_web', '$u_client_web', '$pass_client_web', '$u_domain_web', '$pass_domain_web', '$no_urut','$catatan_web')") or die(mysql_error());
- /* Insert t_bot */
- mysql_query("INSERT INTO t_bot (nm_bot, email, lisensi, id_prospek) values ('$nm_bot', '$email_bot', '$lisensi_bot', '$no_urut')") or die(mysql_error());
- /* Insert t_sos */
- mysql_query("INSERT INTO t_sos (email, j_member, level_sos, id_prospek) values ('$email_sos', '$j_member', '$level_sos', '$no_urut')") or die(mysql_error());
- echo '<META HTTP-EQUIV="Refresh" Content="0; URL=?page=prospek">';
- }
- //Cek Email
- if($cek_email > 0){
- echo "<script type='text/javascript'>alert('maaf data email sudah ada');</script>";
- }else{
- /* Insert t_prospek */
- mysql_query("INSERT INTO t_prospek (no_urut, no_invoice, nama, pin, line , no_hp, wa, email, asal_kota, produk, kat_produk, fb, twitter, ig, web, nama_karyawan, konsumen, j_konsumen, prospek, j_prospek, tgl_input, waktu_input, user_id) values ('$no_urut', '$no_invoice', '$nama', '$pin', '$line', '$hp', '$wa', '$email', '$kota', '$produk', '$kategori', '$fb', '$twitter', '$ig', '$web', '$nama_karyawan', '$konsumen', '$j_konsumen', '$prospek', '$j_prospek', NOW(), NOW(), '$_SESSION[userid]')") or die (mysql_error());
- /* Insert t_aplikasi */
- mysql_query("INSERT INTO t_aplikasi (nama_aplikasi, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_aplikasi', '$domain', '$tgl_order', '$expired','".str_replace(".","",$harga_paket)."','".str_replace(".","",$harga_perpanjangan)."', '$t_hosting', '$paket_hosting', '$penyedia_domain', '$u_cpanel', '$pass_cpanel', '$u_client', '$pass_client', '$u_domain', '$pass_domain', '$no_urut', '$catatan')") or die(mysql_error());
- /* Insert t_web */
- mysql_query("INSERT INTO t_web (nama_web, domain, tgl_order, expired, harga_paket, harga_perpanjangan, provider_hosting, paket_hosting, penyedia_domain, user_cpanel, pass_cpanel, user_klien, pass_klien, user_domain, pass_domain, id_prospek, catatan) values ('$nm_web', '$domain_web', '$tgl_order_web', '$expired_web','".str_replace(".","",$harga_paket_web)."','".str_replace(".","",$perpanjangan_web)."', '$t_hosting_web', '$paket_hosting_web', '$penyedia_domain_web', '$u_cpanel_web', '$pass_cpanel_web', '$u_client_web', '$pass_client_web', '$u_domain_web', '$pass_domain_web', '$no_urut','$catatan_web')") or die(mysql_error());
- /* Insert t_bot */
- mysql_query("INSERT INTO t_bot (nm_bot, email, lisensi, id_prospek) values ('$nm_bot', '$email_bot', '$lisensi_bot', '$no_urut')") or die(mysql_error());
- /* Insert t_sos */
- mysql_query("INSERT INTO t_sos (email, j_member, level_sos, id_prospek) values ('$email_sos', '$j_member', '$level_sos', '$no_urut')") or die(mysql_error());
- echo '<META HTTP-EQUIV="Refresh" Content="0; URL=?page=prospek">';
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement