Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package webauto;
- import java.io.FileInputStream;
- import java.io.IOException;
- import java.io.InputStream;
- import java.io.PrintStream;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.text.DateFormat;
- import java.text.NumberFormat;
- import java.text.SimpleDateFormat;
- import java.util.Calendar;
- import java.util.Iterator;
- import java.util.List;
- import java.util.Properties;
- import java.util.Random;
- import java.util.Scanner;
- import org.openqa.selenium.By;
- import org.openqa.selenium.Dimension;
- import org.openqa.selenium.JavascriptExecutor;
- import org.openqa.selenium.WebDriver;
- import org.openqa.selenium.WebDriver.Options;
- import org.openqa.selenium.WebDriver.Window;
- import org.openqa.selenium.WebElement;
- import org.openqa.selenium.chrome.ChromeDriver;
- import org.openqa.selenium.support.ui.ExpectedCondition;
- import org.openqa.selenium.support.ui.Select;
- import org.openqa.selenium.support.ui.WebDriverWait;
- public class WebAuto
- {
- public WebAuto() {}
- private static WebDriver driver = null;
- private static Connection conmysql = null;
- private static final DateFormat sdf = new SimpleDateFormat("yyMMddHHmmss");
- private static void logdata(String s) { System.out.println(s); }
- public static void waitForPageLoaded() {
- ExpectedCondition<Boolean> expectation = new ExpectedCondition()
- {
- public Boolean apply(WebDriver driver) {
- return Boolean.valueOf(((JavascriptExecutor)driver).executeScript("return document.readyState", new Object[0]).toString().equals("complete"));
- }
- };
- try {
- Thread.sleep(1000L);
- WebDriverWait wait = new WebDriverWait(driver, 30L);
- wait.until(expectation);
- } catch (Throwable error) {
- logdata(error.getMessage());
- }
- }
- public static void main(String[] args)
- {
- String DB_HOST = "";
- String DB_USER = "";
- String DB_PASS = "";
- String DB_PORT = "";
- String DB_NAME = "";
- String ID_TERMINAL = "";
- String DIGIPOS_USER = "";
- String DIGIPOS_PASS = "";
- String DIGIPOS_PIN = "";
- String DIGIPOS_PAKET = "";
- String DIGIPOS_PRODUK = "";
- Integer DIGIPOS_MAX_PRICE = Integer.valueOf(0);
- String JENIS_TRANSAKSI = "";
- Properties prop = new Properties();
- InputStream input = null;
- Integer AUTO_SUKSES = Integer.valueOf(1);
- Integer MAX_LOS = Integer.valueOf(60);
- Integer REFRESH_WEB = Integer.valueOf(120);
- Integer HARGA_INT = Integer.valueOf(0);
- String PAKET_BULK = "";
- float hargabeli = 0.0F;
- try
- {
- input = new FileInputStream("digipos.properties");
- prop.load(input);
- DB_HOST = prop.getProperty("db.host");
- DB_NAME = prop.getProperty("db.name");
- DB_USER = prop.getProperty("db.user");
- DB_PASS = prop.getProperty("db.pass");
- DB_PORT = prop.getProperty("db.port");
- DIGIPOS_USER = prop.getProperty("digipos.user");
- DIGIPOS_PASS = prop.getProperty("digipos.pass");
- DIGIPOS_PIN = prop.getProperty("digipos.pin");
- ID_TERMINAL = prop.getProperty("idterminal");
- AUTO_SUKSES = Integer.valueOf(Integer.parseInt(prop.getProperty("autosukses")));
- MAX_LOS = Integer.valueOf(Integer.parseInt(prop.getProperty("maxlos")));
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- conmysql = DriverManager.getConnection("jdbc:mysql://" + DB_HOST + ":" + DB_PORT + "/" + DB_NAME, DB_USER, DB_PASS);
- Statement stmt = conmysql.createStatement();
- ResultSet localResultSet1 = stmt.executeQuery("select * from masterreseller");
- }
- catch (Exception e)
- {
- System.out.println(e);
- System.out.println("Cek Configurasi database username atau password");
- System.exit(0);
- }
- }
- catch (IOException e)
- {
- e.printStackTrace();
- System.exit(0);
- }
- System.out.println("Starting WebBrowser....");
- String os = System.getProperty("os.name").toLowerCase();
- System.out.println(os);
- if (os.contains("mac"))
- {
- System.setProperty("webdriver.gecko.drive", System.getProperty("user.dir") + "/chromedriver");
- } else {
- System.setProperty("webdriver.gecko.drive", System.getProperty("user.dir") + "\\geckodriver.exe");
- }
- driver = new ChromeDriver();
- driver.manage().window().setSize(new Dimension(400, 800));
- driver.get("https://digipos.telkomsel.com/outapp/");
- System.out.println("wait pageloading...");
- waitForPageLoaded();
- System.out.println("wait ok");
- if (isReqireLogin()) {
- System.err.println("Silahkan Login...");
- } else {
- System.err.println("Not Requere Login");
- }
- driver.findElement(By.id("u")).sendKeys(new CharSequence[] { DIGIPOS_USER });
- driver.findElement(By.id("p")).sendKeys(new CharSequence[] { DIGIPOS_PASS });
- driver.findElement(By.xpath("/html/body/div[1]/div/div[1]/div[1]/button")).click();
- System.out.println("Enter your OTP: ");
- Scanner scannerOtp = new Scanner(System.in);
- String _otp = scannerOtp.nextLine();
- System.out.println("Your OTP is " + _otp);
- driver.findElement(By.name("pinOtp")).sendKeys(new CharSequence[] { _otp });
- driver.findElement(By.xpath("/html/body/div[2]/div[2]/div/div/div/button[2]")).click();
- waitForPageLoaded();
- System.out.println("wait pageloading...");
- waitForPageLoaded();
- System.out.println("wait ok");
- String _msisdnx = getMSISDN();
- waitForPageLoaded();
- driver.findElement(By.xpath("/html/body/div[1]/div/div[1]/div/div/div[2]/div/div/div/div[1]/a[3]")).click();
- waitForPageLoaded();
- try
- {
- for (;;)
- {
- REFRESH_WEB = Integer.valueOf(REFRESH_WEB.intValue() - 1);
- Statement stmt = conmysql.createStatement();
- ResultSet trxbin = stmt.executeQuery("select * from transaksibin where idterminal=" + ID_TERMINAL + " limit 1");
- while (trxbin.next()) {
- REFRESH_WEB = Integer.valueOf(120);
- String _idproduk = trxbin.getString("IDPRODUK");
- JENIS_TRANSAKSI = trxbin.getString("JENISTRANSAKSI");
- String _idtrxbin = trxbin.getString("idtransaksi");
- String _tujuan = trxbin.getString("Tujuan");
- String _kodeinbox = trxbin.getString("KodeInboxCenter");
- String _idprodukterminal = "";
- String _product = "";
- Statement stmtx = conmysql.createStatement();
- String sql = "select idprodukterminal,formatkeluar,hargabeli from produkterminal where idproduk=" + _idproduk + " and idterminal=" + ID_TERMINAL;
- ResultSet ProdukTerminal = stmtx.executeQuery(sql);
- while (ProdukTerminal.next())
- {
- hargabeli = ProdukTerminal.getFloat("hargabeli");
- _product = ProdukTerminal.getString("formatkeluar");
- DIGIPOS_PAKET = _product.split("#")[0];
- if ((DIGIPOS_PAKET.equals("AP_BULK")) || (DIGIPOS_PAKET.equals("HVC")))
- {
- PAKET_BULK = _product.split("#")[1];
- DIGIPOS_PRODUK = _product.split("#")[2];
- DIGIPOS_MAX_PRICE = Integer.valueOf(Integer.parseInt(_product.split("#")[3]));
- }
- else {
- DIGIPOS_PRODUK = _product.split("#")[1];
- DIGIPOS_MAX_PRICE = Integer.valueOf(Integer.parseInt(_product.split("#")[2]));
- }
- _idprodukterminal = ProdukTerminal.getString("idprodukterminal");
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set statustransaksi=9,keterangan='Prosesing Digipos',hargabeli=" + String.valueOf(hargabeli) + " where idtransaksi=" + _idtrxbin);
- s.close();
- }
- ProdukTerminal.close();
- ProdukTerminal = null;
- System.out.println("Trx:" + _idtrxbin + " MSISDN:" + _tujuan + " Paket:" + DIGIPOS_PAKET + " Code:" + DIGIPOS_PRODUK);
- String sqloutbox = "insert into outboxoperator (idprodukterminal,idinboxcenterasal,tanggal,jam,nohp,tujuan,isi,statussms,flagpesansender,idtransaksi,nomorbalasan,suaramenunggujawaban,idterminal,namaterminal,idreseller,nopengirim,idtransaksiclient,kodeproduk,nominal,tujuantrx,jumlahunit,hargajualreseller,saldoawal,saldoakhir) value(?,?,current_date(),current_time(),?,?,?,9,1,?,'','0',?,?,?,?,?,?,?,?,?,?,?,?) ";
- PreparedStatement preparedStatement = conmysql.prepareStatement(sqloutbox);
- preparedStatement.setString(1, _idprodukterminal);
- preparedStatement.setString(2, _kodeinbox);
- preparedStatement.setString(3, "");
- preparedStatement.setString(4, "");
- preparedStatement.setString(5, _product);
- preparedStatement.setString(6, _idtrxbin);
- preparedStatement.setString(7, ID_TERMINAL);
- preparedStatement.setString(8, "namaterminal");
- preparedStatement.setString(9, trxbin.getString("idreseller"));
- preparedStatement.setString(10, trxbin.getString("nopengirim"));
- preparedStatement.setString(11, trxbin.getString("IdTransaksiClient"));
- preparedStatement.setString(12, trxbin.getString("KodeProduk"));
- preparedStatement.setInt(13, 0);
- preparedStatement.setString(14, _tujuan);
- preparedStatement.setString(15, trxbin.getString("JumlahUnit"));
- preparedStatement.setString(16, trxbin.getString("hargajualreseller"));
- preparedStatement.setString(17, trxbin.getString("saldoawal"));
- preparedStatement.setString(18, trxbin.getString("saldoakhir"));
- preparedStatement.execute();
- preparedStatement.close();
- try
- {
- driver.findElement(By.name("MSISDN")).sendKeys(new CharSequence[] { _tujuan });
- driver.findElement(By.xpath("//input[2]")).click();
- waitForPageLoaded();
- waitForPageLoaded();
- String masaAktif = driver.findElement(By.xpath("/html/body/div[1]/div/div[1]/div[2]/input[3]")).getAttribute("value");
- masaAktif = masaAktif.replace(" hari", "");
- System.out.println("MasaAktif:" + masaAktif);
- if (Integer.parseInt(masaAktif) > MAX_LOS.intValue())
- {
- System.out.println("select paket");
- Select dropdownjenispaketx = new Select(driver.findElement(By.id("25")));
- dropdownjenispaketx.selectByValue(DIGIPOS_PAKET);
- System.out.println("Done select paket");
- waitForPageLoaded();
- waitForPageLoaded();
- waitForPageLoaded();
- Select select;
- if ((DIGIPOS_PAKET.equals("AP_BULK")) || (DIGIPOS_PAKET.equals("HVC")))
- {
- if (Integer.valueOf(masaAktif).intValue() < 60) {}
- List<WebElement> elements = driver.findElements(By.xpath("//select[@id='25']"));
- Integer i = Integer.valueOf(1);
- Integer localInteger1; for (Iterator localIterator = elements.iterator(); localIterator.hasNext();
- localInteger1 = i = Integer.valueOf(i.intValue() + 1))
- {
- WebElement option = (WebElement)localIterator.next();
- if (i.intValue() > 1) {
- select = new Select(option);
- select.selectByValue(PAKET_BULK);
- }
- select = i;
- }
- }
- waitForPageLoaded();
- System.out.println("select produk");
- Select dropdownPaketData = new Select(driver.findElement(By.id("26")));
- try {
- dropdownPaketData.selectByVisibleText(DIGIPOS_PRODUK);
- } catch (Exception e) {
- dropdownPaketData.selectByVisibleText(_product.split("#")[4]);
- }
- System.out.println("Done select produk");
- waitForPageLoaded();
- String namaproduk = driver.findElement(By.xpath("/html/body/div[1]/div/div[1]/div[3]/input[1]")).getAttribute("value");
- namaproduk = namaproduk.replace("u0026", " ");
- String stexts = driver.findElement(By.xpath("html/body/div[1]/div/div[1]/div[3]/input[2]")).getAttribute("value");
- HARGA_INT = Integer.valueOf(stexts);
- System.out.println("NamaProduk:" + namaproduk + " Harga:" + stexts);
- if (JENIS_TRANSAKSI.equals("5"))
- {
- sukseskantrx(_idtrxbin, namaproduk, "");
- float hargatagihan = Float.valueOf(stexts).floatValue() + GetMarginFloat(_idproduk, trxbin.getString("PatokanHargaJual")).intValue();
- String _pesanbalasan = _tujuan + " " + '\n' + '\r' + trxbin.getString("KodeProduk") + " " + '\n' + '\r' + namaproduk + " " + '\n' + '\r' + "Harga:" + String.valueOf(hargatagihan);
- String sqltagihan = "insert into tagihanppob (idpelanggan,jumlahtagihan,charge,tanggal,jmltag) value (?,?,?,current_date(),1)";
- PreparedStatement pstagihan = conmysql.prepareStatement(sqltagihan);
- pstagihan.setString(1, _tujuan);
- pstagihan.setFloat(2, hargatagihan);
- pstagihan.setFloat(3, hargatagihan - hargabeli);
- pstagihan.execute();
- pstagihan.close();
- String sqlsender = "insert into sender (idinboxcenterasal,tanggal,jam,tujuan,isi,statussms,idtransaksi,idreseller,namareseller,idtransaksiclient,kodeproduk,tujuantrx,statustrx,sn,jenissender) value (?,current_date(),current_time(),?,?,0,?,?,?,?,?,?,1,'',1)";
- PreparedStatement pssender = conmysql.prepareStatement(sqlsender);
- pssender.setString(1, _kodeinbox);
- pssender.setString(2, trxbin.getString("NoPengirim"));
- pssender.setString(3, _pesanbalasan);
- pssender.setString(4, _idtrxbin);
- pssender.setString(5, trxbin.getString("idreseller"));
- pssender.setString(6, trxbin.getString("namareseller"));
- pssender.setString(7, trxbin.getString("IdTransaksiClient"));
- pssender.setString(8, trxbin.getString("KodeProduk"));
- pssender.setString(9, _tujuan);
- pssender.execute();
- pssender.close();
- reloadpage_activasi_paket();
- }
- else if (DIGIPOS_MAX_PRICE.intValue() >= HARGA_INT.intValue())
- {
- driver.findElement(By.name("PINRS")).sendKeys(new CharSequence[] { DIGIPOS_PIN });
- waitForPageLoaded();
- clickKirim();
- waitForPageLoaded();
- clickOK();
- if (AUTO_SUKSES.equals(Integer.valueOf(1)))
- {
- String snx = generateSN();
- Integer newPrice = Integer.valueOf(trxbin.getInt("HargaJualReseller"));
- Integer hargajualtrx = Integer.valueOf(trxbin.getInt("HARGAJUAL"));
- if (hargajualtrx.intValue() < HARGA_INT.intValue())
- {
- System.out.println("[Harga Digipos Lebih Mahal dari harga jual]");
- Integer _margin = GetMargin(_idproduk, trxbin.getString("PatokanHargaJual"));
- if (_margin.intValue() > 0)
- {
- Integer _haruspotong = Integer.valueOf(HARGA_INT.intValue() + _margin.intValue() - newPrice.intValue());
- System.out.println("Saldo Agen Akan dipotong:" + Integer.valueOf(_haruspotong.intValue()));
- newPrice = Integer.valueOf(HARGA_INT.intValue() + _margin.intValue());
- setHrgjual_trx(_idtrxbin, HARGA_INT, newPrice, Integer.valueOf(newPrice.intValue() + getSelisih(trxbin.getString("idreseller")).intValue()));
- potongsaldo(trxbin.getString("idreseller"), "selisih kenaikan harga:" + trxbin.getString("KodeProduk"), _haruspotong);
- }
- else {
- System.out.println("[Set Margin 0, saldo agen tidak dipotong]");
- }
- }
- sukseskantrx(_idtrxbin, namaproduk, namaproduk);
- String _pesanbalasan = getBalasan("1");
- _pesanbalasan = _pesanbalasan.replace("<Tujuan>", _tujuan);
- _pesanbalasan = _pesanbalasan.replace("<Harga>", formatAngka(newPrice));
- _pesanbalasan = _pesanbalasan.replace("<Harga>", formatAngka(newPrice));
- _pesanbalasan = _pesanbalasan.replace("<Harga>", formatAngka(newPrice));
- _pesanbalasan = _pesanbalasan.replace("<SalAwal>", trxbin.getString("saldoawal"));
- _pesanbalasan = _pesanbalasan.replace("<Waktu>", GetWaktu());
- _pesanbalasan = _pesanbalasan.replace("<Info>", "");
- _pesanbalasan = _pesanbalasan.replace("<SN>", namaproduk);
- _pesanbalasan = _pesanbalasan.replace("<Produk>", trxbin.getString("KodeProduk"));
- _pesanbalasan = _pesanbalasan.replace("<Saldo>", getSaldo(trxbin.getString("idreseller")));
- String _trxclient = trxbin.getString("IdTransaksiClient");
- if (_trxclient.equals("")) {
- _pesanbalasan = _pesanbalasan.replace("<ReffClient>", "");
- } else {
- _pesanbalasan = _pesanbalasan.replace("<ReffClient>", _trxclient);
- }
- String sqlsender = "insert into sender (idinboxcenterasal,tanggal,jam,tujuan,isi,statussms,idtransaksi,idreseller,namareseller,idtransaksiclient,kodeproduk,tujuantrx,statustrx,sn,jenissender) value (?,current_date(),current_time(),?,?,0,?,?,?,?,?,?,1,'',1)";
- PreparedStatement pssender = conmysql.prepareStatement(sqlsender);
- pssender.setString(1, _kodeinbox);
- pssender.setString(2, trxbin.getString("NoPengirim"));
- pssender.setString(3, _pesanbalasan);
- pssender.setString(4, _idtrxbin);
- pssender.setString(5, trxbin.getString("idreseller"));
- pssender.setString(6, trxbin.getString("namareseller"));
- pssender.setString(7, trxbin.getString("IdTransaksiClient"));
- pssender.setString(8, trxbin.getString("KodeProduk"));
- pssender.setString(9, _tujuan);
- pssender.execute();
- pssender.close();
- }
- waitForPageLoaded();
- }
- else
- {
- gagalkantrx(_idtrxbin);
- String _pesanbalasan = getBalasan("10");
- _pesanbalasan = _pesanbalasan.replace("<Tujuan>", _tujuan);
- _pesanbalasan = _pesanbalasan.replace("<Waktu>", GetWaktu());
- _pesanbalasan = _pesanbalasan.replace("<Info>", "");
- _pesanbalasan = _pesanbalasan.replace("<Produk>", trxbin.getString("KodeProduk"));
- _pesanbalasan = _pesanbalasan.replace("<Saldo>", getSaldo(trxbin.getString("idreseller")));
- String _trxclient = trxbin.getString("IdTransaksiClient");
- if (_trxclient.equals("")) {
- _pesanbalasan = _pesanbalasan.replace("<ReffClient>", "");
- } else {
- _pesanbalasan = _pesanbalasan.replace("<ReffClient>", _trxclient);
- }
- String sqlsender = "insert into sender (idinboxcenterasal,tanggal,jam,tujuan,isi,statussms,idtransaksi,idreseller,namareseller,idtransaksiclient,kodeproduk,tujuantrx,statustrx,sn,jenissender) value (?,current_date(),current_time(),?,?,0,?,?,?,?,?,?,2,'',1)";
- PreparedStatement pssender = conmysql.prepareStatement(sqlsender);
- pssender.setString(1, _kodeinbox);
- pssender.setString(2, trxbin.getString("NoPengirim"));
- pssender.setString(3, _pesanbalasan);
- pssender.setString(4, _idtrxbin);
- pssender.setString(5, trxbin.getString("idreseller"));
- pssender.setString(6, trxbin.getString("namareseller"));
- pssender.setString(7, trxbin.getString("IdTransaksiClient"));
- pssender.setString(8, trxbin.getString("KodeProduk"));
- pssender.setString(9, _tujuan);
- pssender.execute();
- pssender.close();
- driver.get("https://digipos.telkomsel.com/outapp/aktivasipaket");
- waitForPageLoaded();
- }
- }
- else
- {
- System.out.println("[LOS Melebihi batas]");
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set statustransaksi=8,keterangan='LOS dibawah nilai yg di tentukan' where idtransaksi=" + _idtrxbin);
- s.close();
- Statement sx = conmysql.createStatement();
- sx.execute("update outboxoperator set statussms=8 where idtransaksi=" + _idtrxbin);
- sx.close();
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- System.err.println("Error_Trx:" + e.getMessage());
- System.out.println("INVALID KODE PRODUK");
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set statustransaksi=8,keterangan='Error invalid kode produk' where idtransaksi=" + _idtrxbin);
- s.close();
- driver.get("https://digipos.telkomsel.com/outapp/aktivasipaket");
- waitForPageLoaded();
- }
- }
- trxbin.close();
- trxbin = null;
- stmt.close();
- stmt = null;
- Thread.sleep(300L);
- if (REFRESH_WEB.intValue() < 0) {
- System.out.println("Refresh webpage...");
- driver.get("https://digipos.telkomsel.com/outapp/aktivasipaket");
- waitForPageLoaded();
- REFRESH_WEB = Integer.valueOf(120);
- }
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static Integer GetMarginFloat(String _idproduk, String _patokanhargajual)
- {
- Integer _margin = Integer.valueOf(0);
- try
- {
- Statement stmty = conmysql.createStatement();
- String sqlxx = "select margin from detailkelompokharga where idkelompokharga=" + _patokanhargajual + " and idproduk=" + _idproduk;
- ResultSet rssaldo = stmty.executeQuery(sqlxx);
- while (rssaldo.next()) {
- _margin = Integer.valueOf(rssaldo.getInt("margin"));
- }
- rssaldo.close();
- stmty.close();
- } catch (Exception e) {
- e.printStackTrace();
- System.err.println("Error_GetSaldo:" + e.getMessage());
- }
- return _margin;
- }
- public static void setHrgjual_trx(String _idtrx, Integer hargabeli, Integer hargajual, Integer hargajualreseller)
- {
- try {
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set hargabeli=" + hargabeli + ",hargajual=" + hargajual + ",hargajualreseller=" + hargajualreseller + " where idtransaksi=" + _idtrx);
- s.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static Integer getSelisih(String _idrs) {
- Integer _selisih = Integer.valueOf(0);
- try
- {
- Statement stmty = conmysql.createStatement();
- ResultSet rsx = stmty.executeQuery("select idupline,tambahanhargapribadi from masterreseller where idreseller='" + _idrs + "'");
- if (rsx.next()) {
- _selisih = Integer.valueOf(rsx.getInt("tambahanhargapribadi"));
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- return _selisih;
- }
- public static Integer AmbilSelisihUpline(String _idrs, String _idproduk) {
- Integer _selisih = Integer.valueOf(0);
- String _idupline = "";
- String _paramIdupline = "";
- String _paramBeforeIdupline = "";
- Integer _keluar = Integer.valueOf(0);
- try {
- Statement stmty = conmysql.createStatement();
- ResultSet rsup = stmty.executeQuery("select idupline from masterreseller where idreseller='" + _idrs + "'");
- _paramIdupline = _idrs;
- if (rsup.next()) {
- _idupline = rsup.getString("idupline");
- if (!_idupline.equals("-"))
- {
- while (_keluar.equals(Integer.valueOf(0)))
- {
- ResultSet rsx = stmty.executeQuery("select idupline,tambahanhargapribadi from masterreseller where idreseller='" + _paramIdupline + "'");
- if (rsx.next())
- {
- if (rsup.getString("idupline").equals("-"))
- {
- _keluar = Integer.valueOf(1);
- _selisih = Integer.valueOf(rsup.getInt("tambahanhargapribadi"));
- }
- else
- {
- _paramBeforeIdupline = _paramIdupline;
- _paramIdupline = rsup.getString("idupline");
- ResultSet rsxx = stmty.executeQuery("select markup from markupperproduk where idreseller='" + _paramBeforeIdupline + "' and idproduk=" + _idproduk);
- if (rsx.next()) {
- _selisih = Integer.valueOf(_selisih.intValue() + rsup.getInt("markup"));
- } else {
- _selisih = Integer.valueOf(_selisih.intValue() + getSelisih(_paramBeforeIdupline).intValue());
- }
- }
- }
- else {
- _keluar = Integer.valueOf(1);
- }
- Thread.sleep(100L);
- }
- }
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- return _selisih;
- }
- public static void potongsaldo(String _idreseller, String _keterangan, Integer jumlah) {
- try {
- Statement s = conmysql.createStatement();
- s.execute("select tambahhistorireseller('" + _idreseller + "','" + _keterangan + "'," + jumlah + ")");
- s.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static Integer GetMargin(String _idproduk, String _patokanhargajual) {
- Integer _margin = Integer.valueOf(0);
- try
- {
- Statement stmty = conmysql.createStatement();
- String sqlxx = "select margin from detailkelompokharga where idkelompokharga=" + _patokanhargajual + " and idproduk=" + _idproduk;
- ResultSet rssaldo = stmty.executeQuery(sqlxx);
- while (rssaldo.next()) {
- _margin = Integer.valueOf(rssaldo.getInt("margin"));
- }
- rssaldo.close();
- stmty.close();
- } catch (Exception e) {
- e.printStackTrace();
- System.err.println("Error_GetSaldo:" + e.getMessage());
- }
- return _margin;
- }
- public static String formatAngka(Integer bilangan1) {
- NumberFormat numberFormat = NumberFormat.getInstance();
- numberFormat.setMinimumIntegerDigits(0);
- numberFormat.setGroupingUsed(true);
- return numberFormat.format(bilangan1);
- }
- public static String GetWaktu() { DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss");
- Calendar cal = Calendar.getInstance();
- return dateFormat.format(cal.getTime());
- }
- public static String generateSN() {
- Random rand = new Random();
- int n = rand.nextInt(500) + 1;
- Calendar cal = Calendar.getInstance();
- return sdf.format(cal.getTime()) + rightPadZeros(String.valueOf(n), 4);
- }
- public static String rightPadZeros(String str, int num) {
- return String.format("%1$-" + num + "s", new Object[] { str }).replace(' ', '0');
- }
- public static String fixedLengthString(String string, int length) { return String.format("%1$" + length + "s", new Object[] { string }); }
- public static void gagalkantrx(String _idtrxbin) {
- try {
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set statustransaksi=2,keterangan='invalid kode produk' where idtransaksi=" + _idtrxbin);
- s.execute("update outboxoperator set statussms=2 where idtransaksi=" + _idtrxbin);
- s.close();
- }
- catch (Exception localException) {}
- }
- public static void sukseskantrx(String _idtrxbin, String msg, String sn) {
- try {
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set statustransaksi=1,keterangan='" + msg + "',sn='" + sn + "' where idtransaksi=" + _idtrxbin);
- s.execute("update outboxoperator set statussms=1 where idtransaksi=" + _idtrxbin);
- s.close();
- }
- catch (Exception localException) {}
- }
- public static void reloadpage_activasi_paket() {
- driver.get("https://digipos.telkomsel.com/outapp/aktivasipaket");
- waitForPageLoaded();
- }
- public static String getSaldo(String idreseller) {
- String _saldo = "";
- try
- {
- Statement stmty = conmysql.createStatement();
- String sqlxx = "select saldo from masterreseller where idreseller='" + idreseller + "'";
- ResultSet rssaldo = stmty.executeQuery(sqlxx);
- while (rssaldo.next()) {
- _saldo = formatAngka(Integer.valueOf(rssaldo.getInt("saldo")));
- }
- rssaldo.close();
- stmty.close();
- } catch (Exception e) {
- e.printStackTrace();
- System.err.println("Error_GetSaldo:" + e.getMessage());
- }
- return _saldo;
- }
- public static String getBalasan(String Idbalasan) {
- String balasan = "";
- try
- {
- Statement stmtx = conmysql.createStatement();
- String sqlx = "select Format from smsbalasan where idsmsbalasan=" + Idbalasan;
- ResultSet smsbalasan = stmtx.executeQuery(sqlx);
- while (smsbalasan.next()) {
- balasan = smsbalasan.getString("Format");
- }
- smsbalasan.close();
- stmtx.close();
- } catch (Exception e) {
- e.printStackTrace();
- System.err.println("Error_getBalasan:" + e.getMessage());
- }
- return balasan;
- }
- public static String getKodeSuplier(String _idproduk, String _idterminal, String _idtrx) {
- String kodepSuplier = "";
- try {
- Statement stmt = conmysql.createStatement();
- String sql = "select formatkeluar,hargabeli from produkterminal where idproduk=" + _idproduk + " and idterminal=" + _idterminal;
- System.out.println(sql);
- ResultSet ProdukTerminal = stmt.executeQuery(sql);
- while (ProdukTerminal.next())
- {
- float hargabeli = ProdukTerminal.getFloat("hargabeli");
- kodepSuplier = ProdukTerminal.getString("formatkeluar");
- Statement s = conmysql.createStatement();
- s.execute("update transaksi set statustransaksi=9,keterangan='Prosesing Digipos',hargabeli=" + String.valueOf(hargabeli) + " where idtransaksi=" + _idtrx);
- s.close();
- }
- ProdukTerminal.close();
- }
- catch (Exception e)
- {
- e.printStackTrace();
- System.err.println("Error_getKodeSuplier:" + e.getMessage());
- }
- return kodepSuplier;
- }
- public static void closeMYSQL()
- {
- try
- {
- conmysql.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- public static void inputOTP(String _otp) {
- driver.findElement(By.name("pinOtp")).sendKeys(new CharSequence[] { _otp });
- driver.findElement(By.xpath("/html/body/div[2]/div[2]/div/div/div/button[2]")).click();
- waitForPageLoaded();
- }
- public static boolean isReqireLogin() { return driver.findElement(By.id("u")).isDisplayed(); }
- public static void clickback() {
- driver.findElement(By.className("IconHome")).click();
- waitForPageLoaded();
- }
- public static void clickOK() { driver.findElement(By.xpath("/html/body/div[3]/div[2]/div/div/div/button")).click();
- waitForPageLoaded();
- }
- public static void clickKirim() { driver.findElement(By.xpath("/html/body/div[1]/div/div[1]/div[3]/div[3]/button")).click();
- waitForPageLoaded();
- }
- public static String getMSISDN() {
- System.out.println("Press Enter to Continue....");
- Scanner scannerinput = new Scanner(System.in);
- String _inputan = scannerinput.nextLine();
- return _inputan;
- }
- public static String getProductPackage() {
- System.out.println("Enter Product Package: ");
- Scanner scannerinput = new Scanner(System.in);
- String _inputan = scannerinput.nextLine();
- System.out.println("Your Package is " + _inputan);
- return _inputan;
- }
- public static String getPin() { System.out.println("Enter Your PIN: ");
- Scanner scannerinput = new Scanner(System.in);
- String _inputan = scannerinput.nextLine();
- System.out.println("Your PIN is " + _inputan);
- return _inputan;
- }
- }
- Twitter Facebook Stumbleupon LinkedIn
- Select a decompiler
- JDCore (very fast)
- CFR (very good and well-supported decompiler for Java 7, 8, 9 and 10)
- Jadx, fast and with Android support
- Procyon
- Fernflower
- JAD (very fast, but outdated)
- Privacy Policy
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement