Example #1
0
  @Override
  public List<CategorieCustomer> getAllCategorieCustomer(Compte c) {
    // TODO Auto-generated method stub
    List<CategorieCustomer> res = new ArrayList<>();

    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

    nameValuePairs.add(new BasicNameValuePair("username", c.getLogin()));
    nameValuePairs.add(new BasicNameValuePair("password", c.getPassword()));

    try {
      String jsonString = jsonParser.makeHttpRequest(urlcatclt, "POST", nameValuePairs);

      JSONObject obj = new JSONObject(jsonString);

      JSONArray lsfree = obj.getJSONArray("lsfree");
      JSONArray lscat = obj.getJSONArray("lscategories");

      List<Integer> tmp = new ArrayList<>();
      for (int i = 0; i < lsfree.length(); i++) {
        tmp.add(lsfree.getInt(i));
      }

      res.add(new CategorieCustomer(0, "Categorie par defaut", "Categorie par defaut", tmp));

      for (int i = 0; i < lscat.length(); i++) {
        JSONObject jb = lscat.getJSONObject(i);

        tmp = new ArrayList<>();
        for (int j = 0; j < jb.getJSONArray("clts").length(); j++) {
          tmp.add(jb.getJSONArray("clts").getInt(j));
        }
        res.add(
            new CategorieCustomer(
                jb.getInt("id"), jb.getString("label"), jb.getString("description"), tmp));
      }

      Log.e("secto  ", " " + res.size());
    } catch (Exception e) {
      // TODO: handle exception
      Log.e("VendeurDaoMysql error parse secteur getAllCategorieCustomer ", e.getMessage() + "  ");
      res = new ArrayList<>();
      MyDebug.WriteLog(
          this.getClass().getSimpleName(),
          "getAllCategorieCustomer",
          nameValuePairs.toString(),
          e.toString());
    }

    return res;
  }
Example #2
0
  @Override
  public Dictionnaire getDictionnaire() {
    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

    nameValuePairs.add(new BasicNameValuePair("all", "okk"));

    String jsonString = jsonParser.makeHttpRequest(urlprd, "POST", nameValuePairs);
    // Parse les donn�es JSON

    ArrayList<HashMap<String, String>> mapsss = new ArrayList<>();

    try {

      JSONArray jArray = new JSONArray(jsonString);
      // check your log for json response
      // Log.d("Dictionnaire", jArray.);

      // [{"id":"1","ref":"c00001","desig":"Produit1","stock":"100","pu":"100,00"},
      for (int i = 0; i < jArray.length(); i++) {
        JSONArray dico = jArray.getJSONArray(i);
        for (int j = 0; j < dico.length(); j++) {
          JSONObject jsone = dico.getJSONObject(j);
          HashMap<String, String> dic = new HashMap<>();
          dic.put(jsone.getString("code"), jsone.getString("libelle"));
          mapsss.add(dic);
        }
      }
    } catch (Exception e) {
      Log.e("VendeurDaoMysql log_tag", "Error parsing data getDictionnaire " + e.toString());
      MyDebug.WriteLog(
          this.getClass().getSimpleName(),
          "getDictionnaire",
          nameValuePairs.toString(),
          e.toString());
    }

    dicot.setDico(mapsss);
    // Log.i("Dictionnaire >> ",dicot.toString());

    return dicot;
  }
    @Override
    protected String doInBackground(Void... params) {

      ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
      nameValuePairs.add(new BasicNameValuePair("username", compte.getLogin()));
      nameValuePairs.add(new BasicNameValuePair("password", compte.getPassword()));
      nameValuePairs.add(new BasicNameValuePair("user", compte.getId() + ""));
      nameValuePairs.add(new BasicNameValuePair("serveur", serveur.getText().toString()));
      nameValuePairs.add(new BasicNameValuePair("bd", bd.getText().toString()));
      nameValuePairs.add(new BasicNameValuePair("login", login.getText().toString()));
      nameValuePairs.add(new BasicNameValuePair("pass", pass.getText().toString()));
      nameValuePairs.add(new BasicNameValuePair("table", table.getText().toString()));
      nameValuePairs.add(new BasicNameValuePair("lat", lat.getText().toString()));
      nameValuePairs.add(new BasicNameValuePair("lng", lng.getText().toString()));

      String url = "http://41.142.241.192/crm1/htdocs/android/gps.php";

      String jsonString = jsonParser.makeHttpRequest(url, "POST", nameValuePairs);

      Log.e("recuperation", jsonString);

      try {

        JSONObject json = new JSONObject(jsonString);
        if ("yes".equals(json.getString("ok"))) {
          Log.e("ajouter", "Bien Ajouter");
          return "success";
        } else {
          Log.e("ohoy", "Error d'insertion");
          return "error";
        }
      } catch (Exception e) {
        Log.e("log_tag", "Error in http connection " + e.toString());
        return "0";
      }
    }
Example #4
0
  @Override
  public List<Produit> selectAllProduct(Compte c) {
    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

    nameValuePairs.add(new BasicNameValuePair("username", c.getLogin()));
    nameValuePairs.add(new BasicNameValuePair("password", c.getPassword()));

    String jsonString = jsonParser.makeHttpRequest(urlprd, "POST", nameValuePairs);
    // Parse les donn�es JSON

    List<Produit> list = new ArrayList<Produit>();

    ArrayList<HashMap<String, String>> mapsss = new ArrayList<>();

    listPromoByProduits = new HashMap<>();

    Log.e("Json retourne >> ", jsonString);
    try {

      JSONArray jArray = new JSONArray(jsonString);
      // check your log for json response
      // Log.d("Dictionnaire", jArray.);

      // [{"id":"1","ref":"c00001","desig":"Produit1","stock":"100","pu":"100,00"},
      for (int i = 0; i < jArray.length(); i++) {
        if (i == 0) {
          JSONArray dico = jArray.getJSONArray(i);
          for (int j = 0; j < dico.length(); j++) {
            JSONObject jsone = dico.getJSONObject(j);
            HashMap<String, String> dic = new HashMap<>();
            dic.put(jsone.getString("code"), jsone.getString("libelle"));
            mapsss.add(dic);
          }
        } else {
          JSONObject json = jArray.getJSONObject(i);
          Produit produit = new Produit();
          // Log.e(">>> Produit trouver Successful!", json.toString());

          /*
          String pu = json.getString("pu");
          String[] parts = pu.split(".");

          String mni = parts[1].substring(0, 1);

          String part = parts[1]+"."+ mni;
          for (int j = 0; j < parts.length; j++) {
          	part += Integer.parseInt(parts[j]);
          }
           */

          produit.setId(json.getInt("id"));
          produit.setDesig(json.getString("desig"));
          produit.setPrixUnitaire(json.getString("pu"));
          produit.setQteDispo(json.getInt("stock"));
          produit.setRef(json.getString("ref"));
          produit.setPrixttc(json.getDouble("price_ttc"));
          produit.setFk_tva(json.getString("fk_tva"));
          produit.setTva_tx(json.getString("tva_tx"));
          list.add(produit);

          int nombre_promos = json.getInt("nombre_promotion");
          HashMap<Integer, Promotion> map = new HashMap<>();

          if (nombre_promos > 0) {
            for (int j = 0; j < nombre_promos; j++) {

              Promotion p =
                  new Promotion(
                      json.getInt("id_promos" + j),
                      Integer.parseInt(json.getString("type_promos" + j)),
                      Integer.parseInt(json.getString("promos" + j)),
                      Integer.parseInt(json.getString("qte_promos" + j)));
              map.put(p.getId(), p);
            }
          } else {
            Promotion p = new Promotion(0, -1, 0, 0);
            map.put(p.getId(), p);
          }
          listPromoByProduits.put(json.getInt("id"), map);
        }
      }
    } catch (Exception e) {
      Log.e("VendeurDaoMysql log_tag", "Error parsing data selectAllProduct " + e.toString());
      MyDebug.WriteLog(
          this.getClass().getSimpleName(),
          "selectAllProduct",
          nameValuePairs.toString(),
          e.toString());
    }

    dicot.setDico(mapsss);
    // Log.i("Dictionnaire >> ",dicot.toString());

    return list;
  }
Example #5
0
  @Override
  public List<Tournee> consulterMesTournee(Compte c, String dt) {
    // TODO Auto-generated method stub

    List<Tournee> tour = new ArrayList<>();

    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

    nameValuePairs.add(new BasicNameValuePair("user", c.getIduser() + "")); // c.getLogin()
    nameValuePairs.add(new BasicNameValuePair("password", c.getPassword()));
    nameValuePairs.add(new BasicNameValuePair("action", "android"));
    nameValuePairs.add(new BasicNameValuePair("dt", dt));

    Log.e("send durl mes tournee ", nameValuePairs.toString());

    listPromoByClient = new HashMap<>();
    lssociete = new ArrayList<>();

    try {
      String json = jsonParser.makeHttpRequest(urlData, "POST", nameValuePairs);

      Log.e("start", json);

      // [{"rowid":"1","label":"new
      // task","dates":"2015-09-02","datee":"2015-09-19","color":"#0080ff","secteur":"CA","idsecteur":"18","clients":[],"grp":"vendeur","idgrp":"7","usr":"","recur":["1","3","6"]}]
      String stfomat = json.substring(json.indexOf("["), json.lastIndexOf("]") + 1);

      // Log.e("json",stfomat);
      JSONArray jsr = new JSONArray(stfomat);

      for (int i = 0; i < jsr.length(); i++) {
        JSONObject obj = jsr.getJSONObject(i);

        Tournee tr = new Tournee();

        tr.setRowid(obj.getLong("rowid"));
        tr.setLabel(obj.getString("label"));
        tr.setDebut(obj.getString("dates"));
        tr.setFin(obj.getString("datee"));
        tr.setColor(obj.getString("color"));

        tr.setSecteur(obj.getString("secteur"));
        tr.setIdsecteur(obj.getLong("idsecteur"));

        tr.setGrp(obj.getString("grp"));
        tr.setIdgrp(obj.getLong("idgrp"));

        JSONArray cl = obj.getJSONArray("clients");
        List<Client> lsclt = new ArrayList<>();
        for (int j = 0; j < cl.length(); j++) {
          JSONObject o = cl.getJSONObject(j);
          Client ct =
              new Client(
                  o.getInt("rowid"),
                  o.getString("name"),
                  "",
                  o.getString("town"),
                  o.getString("email"),
                  o.getString("phone"),
                  o.getString("address"));

          lsclt.add(ct);

          /** ***************************** Load societe data ********************************* */
          Societe s =
              new Societe(
                  o.getInt("rowid"),
                  o.getString("name"),
                  o.getString("address"),
                  o.getString("town"),
                  o.getString("phone"),
                  o.getString("fax"),
                  o.getString("email"),
                  o.getInt("type"),
                  o.getInt("company"),
                  o.getDouble("latitude"),
                  o.getDouble("longitude"));
          s.setLogo(o.getString("logo"));

          if (o.getString("imgin").equals("ok") && !"".equals(o.getString("logo"))) {

            String imageURL = UrlImage.urlimgclients + o.getString("logo");
            // Log.e(">>> img",imageURL+"");
            Bitmap bitmap = null;
            try {
              // Download Image from URL
              InputStream input = new java.net.URL(imageURL).openStream();
              // Decode Bitmap
              bitmap = BitmapFactory.decodeStream(input);

              File dir = new File(UrlImage.pathimg + "/client_img");
              if (!dir.exists()) dir.mkdirs();

              File file = new File(dir, "/" + o.getString("logo"));
              FileOutputStream fOut = new FileOutputStream(file);

              // Log.e(">>hotos ",produit.getPhoto());

              if (o.getString("logo").split("\\.")[1].equals("jpeg")
                  || o.getString("logo").split("\\.")[1].equals("jpg")
                  || o.getString("logo").split("\\.")[1].equals("jpe")) {
                bitmap.compress(Bitmap.CompressFormat.JPEG, 85, fOut);
              } else {
                bitmap.compress(Bitmap.CompressFormat.PNG, 85, fOut);
              }

              fOut.flush();
              fOut.close();
            } catch (Exception e) {
              e.printStackTrace();
              Log.e(">> ", "pic out clt " + e.getMessage());
            }
          }
          lssociete.add(s);

          /**
           * ************************************* end
           * ***********************************************
           */
          int nombre_promos = o.getInt("nombre_promotion");
          List<Integer> listP = new ArrayList<>();

          if (nombre_promos > 0) {
            for (int f = 0; f < nombre_promos; f++) {
              int idp = Integer.parseInt(o.getString("id_promos" + f));
              listP.add(idp);
            }
          }

          listPromoByClient.put(o.getInt("rowid"), listP);
        }

        tr.setLsclt(lsclt);

        JSONArray rc = obj.getJSONArray("recur");
        List<Integer> lsrc = new ArrayList<>();
        for (int j = 0; j < rc.length(); j++) {

          lsrc.add(rc.getInt(j));
        }

        tr.setRecur(lsrc);

        tour.add(tr);
      }

    } catch (Exception e) {
      // TODO Auto-generated catch block
      tour = new ArrayList<>();
      Log.e("VendeurDaoMysql load tour error consulterMesTournee ", e.getMessage() + "  <<");
      MyDebug.WriteLog(
          this.getClass().getSimpleName(),
          "consulterMesTournee",
          nameValuePairs.toString(),
          e.toString());
    }

    return tour;
  }
Example #6
0
  @Override
  public List<Client> selectAllLastClient(Compte c, String in) {
    // TODO Auto-generated method stub
    ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

    nameValuePairs.add(new BasicNameValuePair("username", c.getLogin()));
    nameValuePairs.add(new BasicNameValuePair("password", c.getPassword()));
    nameValuePairs.add(new BasicNameValuePair("rowid", in));

    String jsonString = jsonParser.makeHttpRequest(urlclt, "POST", nameValuePairs);
    // Parse les donn�es JSON

    List<Client> list = new ArrayList<Client>();

    Log.e("Json retourne >> ", jsonString);
    lssociete = new ArrayList<>();
    try {

      JSONArray jArray = new JSONArray(jsonString);
      // check your log for json response
      // Log.d("Login attempt", jArray.toString());

      for (int i = 0; i < jArray.length(); i++) {
        JSONObject json = jArray.getJSONObject(i);
        Client clt = new Client();

        // "rowid":"3","name":"karouani","client":"1","zip":"54020","town":null,
        // "stcomm":"Jamais contact\u00e9","prefix_comm":null,"code_client":"14589"

        clt.setId(json.getInt("rowid"));
        clt.setName(json.getString("name"));
        clt.setZip(json.getString("zip"));
        clt.setTown(json.getString("town"));
        clt.setLatitude(Double.parseDouble(json.getString("latitude")));
        clt.setLongitude(Double.parseDouble(json.getString("longitude")));
        if (!c.getProfile().toLowerCase().equals("technicien")) {
          clt.setEmail(json.getString("email"));
        }

        int nombre_promos = json.getInt("nombre_promotion");
        List<Integer> listP = new ArrayList<>();

        if (nombre_promos > 0) {
          for (int j = 0; j < nombre_promos; j++) {
            int idp = Integer.parseInt(json.getString("id_promos" + j));
            listP.add(idp);
          }
        }

        listPromoByClient.put(json.getInt("rowid"), listP);
        list.add(clt);

        /** ***************************** Load societe data ********************************* */
        Societe s =
            new Societe(
                json.getInt("rowid"),
                json.getString("name"),
                json.getString("address"),
                json.getString("town"),
                json.getString("phone"),
                json.getString("fax"),
                json.getString("email"),
                json.getInt("type"),
                json.getInt("company"),
                json.getDouble("latitude"),
                json.getDouble("longitude"));
        s.setLogo(json.getString("logo"));

        if (json.getString("imgin").equals("ok") && !"".equals(json.getString("logo"))) {

          String imageURL = UrlImage.urlimgclients + json.getString("logo");
          // Log.e(">>> img",imageURL+"");
          Bitmap bitmap = null;
          try {
            // Download Image from URL
            InputStream input = new java.net.URL(imageURL).openStream();
            // Decode Bitmap
            bitmap = BitmapFactory.decodeStream(input);

            File dir = new File(UrlImage.pathimg + "/client_img");
            if (!dir.exists()) dir.mkdirs();

            File file = new File(dir, "/" + json.getString("logo"));
            FileOutputStream fOut = new FileOutputStream(file);

            // Log.e(">>hotos ",produit.getPhoto());

            if (json.getString("logo").split("\\.")[1].equals("jpeg")
                || json.getString("logo").split("\\.")[1].equals("jpg")
                || json.getString("logo").split("\\.")[1].equals("jpe")) {
              bitmap.compress(Bitmap.CompressFormat.JPEG, 85, fOut);
            } else {
              bitmap.compress(Bitmap.CompressFormat.PNG, 85, fOut);
            }

            fOut.flush();
            fOut.close();
          } catch (Exception e) {
            e.printStackTrace();
            Log.e(">> ", "pic out clt " + e.getMessage());
          }
        }
        lssociete.add(s);
      }
    } catch (Exception e) {
      Log.e("VendeurDaoMysql log_tag", "Error parsing data selectAllLastClient " + e.toString());
      MyDebug.WriteLog(
          this.getClass().getSimpleName(),
          "selectAllLastClient",
          nameValuePairs.toString(),
          e.toString());
    }
    return list;
  }