DAFTAR PUSTAKA Detikinet. 2013. Aplikasi Gratis Membangun SMS Gateway Berbasis Web. (online), 2202782/317/4-aplikasi-gratis(http://inet.detik.com/read/2013/03/25/123122/ membangunsms-gateway-berbasis-web, diakses 9 Februari 2014) Saputra Agus. 2011.Step By Step Membangun Aplikasi SMS Dengan PHP Dan MySQL. Jakarta : PT. Elex Media Komputindo. Saungfos. 2010. Wammu dan Gammu Mengirim dan Menerima Sms Lewat Komputer. (online),(http://saung-foss.web.id/2010/09/05/wammudan-gammu-mengirimdan-menerima-smslewat-Komputer/, diakses 10 Februari 2014) Cihar, Mica. 2011. Gammu Manual. (online), (http://wammu.eu/docs/pdf/gammu.pdf, diakses 8 Februari 2014). Kadir, Abdul. 2014. Pengenalan Sistem Informasi Edisi Revisi.Yogyakarta: Andi Offset. Simarmata.,Janner (2010), Rekayasa Perangkat Lunak. Yogyakarta : Andi Offset Moniaga Jurike V, Irwansyah Edi. 2012. Pengantar Teknologi Informasi Yogyakarta: Deepublish publiser. Arief, M. Rudyanto.2011. Pemrograman Web Dinamis menggunakan PHP dan MYSQL. Yogyakarta : Andi Offset Sibero, Alexander F.K.2012. Kitab Suci Web Programing. Jakarta: Mediakom. Layka, Vishal.2014.Learn Java For WEB Development. New York : Apress. Dennis Alan, Barwara Halley Wixom, Roberta M Roth. 2012. System Analysis and Design UML , Fifth Edition. New Jersey: John wiley & Sons. Nugroho Adi,2010. Perancangan dan Implementasi Sistem Basis Data, Yogyakarta : Andi Offset. Fathansyah. Basis Data. Bandung. 2012. Rizky, Soetam. 2011. Konsep Dasar Rekayasa Perangkat Lunak. Jakarta: Prestasi Pustaka.
http://digilib.mercubuana.ac.id/ 91
LAMPIRAN 1. Script a. Script PHP Validasi SMS 0){ while($row_inbox = mysql_fetch_array($result_inbox)){ $arr = explode(" ", $row_inbox[0]); $received_date = $row_inbox[1]; $sender_number = $row_inbox[2]; if(count($arr)>=7){ $salesman_id = $arr[0]; $tanggal_kirim = $arr[1]; $rc = $arr[3]; $ec = $arr[5]; $noo = $arr[7]; //$tanggal_kirim = date('Y-m-d', strtotime($tanggal_kirim)); //die($date.'-'.$tanggal_kirim); if($tanggal_kirim<=$date){ $sql1 = "SELECT sales_id,date_order FROM t_order WHERE sales_id='$salesman_id' AND date_order='$tanggal_kirim' AND sender_number='$sender_number' "; if($result_order = mysql_query($sql1)){ if(mysql_num_rows($result_order) == 0){ $sql2 = "SELECT * FROM salesman WHERE sales_id='$salesman_id' "; if($result_order1 = mysql_query($sql2)){ if(mysql_num_rows($result_order1) > 0){ $sql = "INSERT INTO t_order (sales_id,date_order,sms_received_date,sender_number,rc1,ec,noo) VALUES ('$salesman_id','$tanggal_kirim',date_format('$received_date','%Y-%m%d'),'$sender_number','$rc','$ec','$noo')"; $retval = mysql_query( $sql, $conn ); //echo($sql.'
');
92
http://digilib.mercubuana.ac.id/
//print_r('ads:'.$arr); //die(); for($x=9;$x
0){ while($row = mysql_fetch_array($result)){ $sql = "INSERT INTO deorder (id_alias,order_id,qty) VALUES ('$alias',LAST_INSERT_ID(),'$qty')"; $retval = mysql_query( $sql, $conn ); echo($sql.'
'); } } } } } }else { echo('Kode Salesman '.$salesman_id.' tidak terdaftar
'); } } }else { echo('Kode '.$salesman_id.' dengan tanggal '.$tanggal_kirim.'sudah ada
'); } } } } } } } ?>
b. Script login.java
package com.skripsi.mercu; import java.io.Serializable; import java.util.List; import javax.faces.application.FacesMessage; import javax.faces.bean.ManagedBean;
93
http://digilib.mercubuana.ac.id/
import javax.faces.bean.ManagedProperty; import javax.faces.bean.SessionScoped; import javax.faces.context.FacesContext; import com.skripsi.mercu.entity.TUser; import com.skripsi.mercu.service.SkripsiService; @ManagedBean(name = "login") @SessionScoped public class Login implements Serializable { /** * */ private static final long serialVersionUID = 1L; @ManagedProperty(value = "#{skripsiService}") private SkripsiService skripsiService; public void setSkripsiService(SkripsiService skripsiService) { this.skripsiService = skripsiService; } private String username; private String password; private String name; private int type; private boolean loggedIn = false; public String login() { List user = skripsiService.getTUser(username, password); if(user.size() != 0) { showMessage(true); type = user.get(0).getUser_type(); name = user.get(0).getName(); loggedIn = true; if(type==1){ return "/form/user/user.xhtml"; }else{ return "/form/dashboard/dashboard.xhtml"; } }else{ showMessage(false); } return "/index.xhtml"; }
94
http://digilib.mercubuana.ac.id/
public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public int getType() { return type; } public void setType(int type) { this.type = type; } public void showMessage(boolean state) { FacesContext context = FacesContext.getCurrentInstance(); if(state){ context.addMessage(null, new FacesMessage("Successful", "Welcome") ); }else{ context.addMessage(null, new FacesMessage("Login Failed", "Incorrect username or password")); } } public String logout(){ FacesContext.getCurrentInstance().getExternalContext().invalidateSessio n(); return "/index.xhtml"; } public boolean isLoggedIn() { return loggedIn; } public String getName() { return name; } public void setName(String name) { this.name = name;
95
http://digilib.mercubuana.ac.id/
} } }
c. Script LoginDao.java package com.skripsi.mercu.dao; import java.util.List; import com.skripsi.mercu.entity.TUser; public interface LoginDao { public List Login (String Username, String Password); }
d. Script LoginDaoImpl.java
import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import com.skripsi.mercu.entity.TUser; @Repository public class LoginDaoImpl implements LoginDao { @Autowired private SessionFactory sessionFactory; @Override public List Login(String Username, String Password) { // TODO Auto-generated method stub Session session = sessionFactory.getCurrentSession(); String Q1 = " from TUser where user_name=:user_name and user_pass=:user_pass "; Query Query1 = session.createSQLQuery(Q1); Query1.setParameter("user_name", Username); Query1.setParameter("user_pass", Password);
96
http://digilib.mercubuana.ac.id/
return session.createQuery(Q1).list(); } }
e. Script TUser.java
package com.skripsi.mercu.entity; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.Table; import javax.persistence.Transient; @Entity @Table(name="user") public class TUser { @Id @Column(name="user_name") private String user_name; @Column(name="user_pass") private String user_pass; @Column(name="user_status") private int user_status; @Column(name="id_type") private int user_type; @Column(name="name") private String name; @Transient private String status_label; public TUser() {} public TUser(String user_pass, String user_name, int id_type, int user_status, String status_label) { super(); this.user_name = user_name; this.user_pass = user_pass; this.user_status = user_status; this.user_type = user_type; this.status_label = status_label; }
97
http://digilib.mercubuana.ac.id/
public String getUser_name() { return user_name; } public void setUser_name(String user_name) { this.user_name = user_name; } public String getUser_pass() { return user_pass; } public void setUser_pass(String user_pass) { this.user_pass = user_pass; } public int getUser_status() { return user_status; } public void setUser_status(int user_status) { this.user_status = user_status; } public int getUser_type() { return user_type; } public void setUser_type(int user_type) { this.user_type = user_type; } public String getStatus_label() { return status_label; } public void setStatus_label(String status_label) { this.status_label = status_label; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
98
http://digilib.mercubuana.ac.id/
f. Script : SkripsiService.java
package com.skripsi.mercu.service; import java.util.Date; import java.util.List; import com.skripsi.mercu.entity.TDashboard; import com.skripsi.mercu.entity.TEPR; import com.skripsi.mercu.entity.TGRSM; import com.skripsi.mercu.entity.THOA; import com.skripsi.mercu.entity.TPCODE; import com.skripsi.mercu.entity.TRSM; import com.skripsi.mercu.entity.TSLM; import com.skripsi.mercu.entity.TTipe_User; import com.skripsi.mercu.entity.TTrendOmzet; import com.skripsi.mercu.entity.TUser; import com.skripsi.mercu.entity.TSUBDIST; import com.skripsi.mercu.entity.TType; public interface SkripsiService { public void insertTSUBDIST(TSUBDIST subdist); public void deleteTSUBDIST(TSUBDIST subdist); public void updateTSUBDIST(TSUBDIST subdist); public TSUBDIST getTSUBDIST(String id); public List getTSUBDIST(); public void insertTHOA(THOA hoa); public void deleteTHOA(THOA hoa); public void updateTHOA(THOA hoa); public THOA getTHOA(String id); public List getTHOA(); public void insertTRSM(TRSM rsm); public void deleteTRSM(TRSM rsm); public void updateTRSM(TRSM rsm); public TRSM getTRSM(String id); public List getTRSM(); public void insertTGRSM(TGRSM grsm); public void deleteTGRSM(TGRSM grsm); public void updateTGRSM(TGRSM grsm); public TGRSM getTGRSM(String id); public List getTGRSM(); public void insertTUser(TUser user);
99
http://digilib.mercubuana.ac.id/
public void deleteTUser(TUser user); public void updateTUser(TUser user); public TUser getTUser(String id); public List getTUser(); public List getTUser(String user, String pass); public void insertTSLM(TSLM slm); public void deleteTSLM(TSLM slm); public void updateTSLM(TSLM slm); public TSLM getTSLM(String id); public List getTSLM();
public void insertTPCODE(TPCODE pcode); public void deleteTPCODE(TPCODE pcode); public void updateTPCODE(TPCODE pcode); public TPCODE getTPCODE(String id); public List getTPCODE(); public void insertTType(TType type); public void deleteTType(TType type); public void updateTType(TType type); public TType getTType(String type); public List getTType(); public List getTSUBDIST(String username, int type); public List getTTipe_User(String username); public List getTDashboard(String username, Date date, int type); public List getTEPR(String username, String product, Date date_from, Date date_to, int type, String subdist); public List getTTrendOmzet(String username, String product, String year, int type, String subdist); }
g. Script : index.htnl
100
http://digilib.mercubuana.ac.id/
101
http://digilib.mercubuana.ac.id/
2. Surat Keterangan Riset
102
http://digilib.mercubuana.ac.id/
3. Kartu Asistensi
103
http://digilib.mercubuana.ac.id/