Subversion Repositories SmartDukaan

Rev

Rev 9645 | Rev 9702 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 9645 Rev 9701
Line 82... Line 82...
82 
	static{
 82 
	static{
83 
		sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
 83 
		sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
84 
		emailFromAddress = "build@shop2020.in";
 84 
		emailFromAddress = "build@shop2020.in";
85 
		password = "cafe@nes";
 85 
		password = "cafe@nes";
86 
		mailer = new GmailUtils();
 86 
		mailer = new GmailUtils();
87 
		//sendTo = new String[]{"vikram.raghav@shop2020.in"};
 87 
		sendTo = new String[]{"vikram.raghav@shop2020.in"};
88 
		sendTo = new String[]{ "sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
 88 
		/*sendTo = new String[]{ "sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
89 
				"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
 89 
				"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
90 
				"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in","amar.kumar@shop2020.in"};
 90 
				"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in","amar.kumar@shop2020.in"};
91 
		itemIdpendingOrdersMap = new HashMap<Long,Long>();
 91 
		*/itemIdpendingOrdersMap = new HashMap<Long,Long>();
92 
		CatalogClient catalogServiceClient = null;
 92 
		CatalogClient catalogServiceClient = null;
93 
		try {
 93 
		try {
94 
			catalogServiceClient = new CatalogClient();
 94 
			catalogServiceClient = new CatalogClient();
95 
		} catch (TTransportException e1) {
 95 
		} catch (TTransportException e1) {
96 
			// TODO Auto-generated catch block
 96 
			// TODO Auto-generated catch block
Line 735... Line 735...
735 
						"\twebsite_hold: " + holdinventory + "\ttotal_held: " +totalheld +"\tdefault_inv: "
 735 
						"\twebsite_hold: " + holdinventory + "\ttotal_held: " +totalheld +"\tdefault_inv: "
736 
						+ defaultinventory + "\theldorders " + heldorders);
 736 
						+ defaultinventory + "\theldorders " + heldorders);
737 
				row =   sheet.getRow((short) iterator);
 737 
				row =   sheet.getRow((short) iterator);
738 
				if(!inventoryItem.getStatus().equals(status.PAUSED)){
 738 
				if(!inventoryItem.getStatus().equals(status.PAUSED)){
739 
					if(inventoryItem.getRisky()){
 739 
					if(inventoryItem.getRisky()){
- 
 
 740 
						if((available - reserve) < totalheld){
- 
 
 741 
							sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld));
- 
 
 742 
						}
- 
 
 743 
						else{
740 
						allocable = available - reserve - totalheld - holdinventory;
 744 
							allocable = available - reserve - totalheld - holdinventory;
741 
						if(allocable < 0){
 745 
							if(allocable < 0){
742 
							allocable = 0;
 746 
								allocable = 0;
- 
 
 747 
							}
- 
 
 748 
							sent_inventory = Math.round(allocable*2/3) + heldforsource - heldorders ;
743 
						}
 749 
						}
744 
						sent_inventory = Math.round(allocable*2/3) + heldforsource - heldorders ;
 - 
 
745 
						//System.out.println("allocable" + allocable + "\t2/3allocable" + Math.round(allocable*2/3) +  "\theld for source" + heldforsource + "\ttotal held" + totalheld +"\theldorders" +  heldorders + "\tFinal Value is : " + (Math.round(allocable*2/3) +  heldforsource - heldorders));
 750 
						//System.out.println("allocable" + allocable + "\t2/3allocable" + Math.round(allocable*2/3) +  "\theld for source" + heldforsource + "\ttotal held" + totalheld +"\theldorders" +  heldorders + "\tFinal Value is : " + (Math.round(allocable*2/3) +  heldforsource - heldorders));
746 
						if(sent_inventory < 0){
 751 
						if(sent_inventory < 0){
747 
							sent_inventory = 0;
 752 
							sent_inventory = 0;
748 
						}
 753 
						}
749 
					}
 754 
					}
Line 777... Line 782...
777 
					row.getCell((short) 1).setCellValue(inventory.getSellerSku());
 782 
					row.getCell((short) 1).setCellValue(inventory.getSellerSku());
778 
					row.getCell((short) 2).setCellValue(inventory.getProductName());
 783 
					row.getCell((short) 2).setCellValue(inventory.getProductName());
779 
					row.getCell((short) 3).setCellValue(inventory.getAvailableInventory());
 784 
					row.getCell((short) 3).setCellValue(inventory.getAvailableInventory());
780 
					row.getCell((short) 4).setCellValue(sent_inventory);
 785 
					row.getCell((short) 4).setCellValue(sent_inventory);
781 
					if(inventory.getAvailableInventory()!=0 && sent_inventory==0){
 786 
					if(inventory.getAvailableInventory()!=0 && sent_inventory==0){
- 
 
 787 
						outOfStockItems.append("<tr>"
- 
 
 788 
								+ "<td>" + inventory.getProductName() +"</td>"
- 
 
 789 
								+"<td>" + sku + "</td>"
782 
						outOfStockItems.append("Product : " +inventory.getProductName()+" Item ID : "+sku+" Old Inventory : "+inventory.getAvailableInventory()+" New Inventory : "+sent_inventory+"\n");
 790 
								+"<td>" + inventory.getAvailableInventory() + "</td>"
- 
 
 791 
								+"<td>" + sent_inventory + "</td>"
- 
 
 792 
								+"</tr>");
783 
					}
 793 
					}
784 
					else if(inventory.getAvailableInventory()==0 && sent_inventory!=0){
 794 
					else if(inventory.getAvailableInventory()==0 && sent_inventory!=0){
- 
 
 795 
						backInStockItems.append("<tr>"
- 
 
 796 
								+ "<td>" + inventory.getProductName() +"</td>"
- 
 
 797 
								+"<td>" + sku + "</td>"
785 
						backInStockItems.append("Product : " +inventory.getProductName()+" Item ID : "+sku+" Old Inventory : "+inventory.getAvailableInventory()+" New Inventory : "+sent_inventory+"\n");
 798 
								+"<td>" + inventory.getAvailableInventory() + "</td>"
- 
 
 799 
								+"<td>" + sent_inventory + "</td>"
- 
 
 800 
								+"</tr>");
786 
					}
 801 
					}
787 
					else{
 802 
					else{
- 
 
 803 
						inventoryChangeItems.append("<tr>"
- 
 
 804 
								+ "<td>" + inventory.getProductName() +"</td>"
- 
 
 805 
								+"<td>" + sku + "</td>"
788 
						inventoryChangeItems.append("Product : " +inventory.getProductName()+" Item ID : "+sku+" Old Inventory : "+inventory.getAvailableInventory()+" New Inventory : "+sent_inventory+"\n");
 806 
								+"<td>" + inventory.getAvailableInventory() + "</td>"
- 
 
 807 
								+"<td>" + sent_inventory + "</td>"
- 
 
 808 
								+"</tr>");
789 
					}
 809 
					}
790 
					if(inventory.isLive()){
 810 
					if(inventory.isLive()){
791 
						row.getCell((short) 5).setCellValue("Yes");
 811 
						row.getCell((short) 5).setCellValue("Yes");
792 
					}
 812 
					}
793 
					else{
 813 
					else{
Line 881... Line 901...
881 
				} catch (Exception ex) {
 901 
				} catch (Exception ex) {
882 
					ex.printStackTrace();
 902 
					ex.printStackTrace();
883 
				}
 903 
				}
884 
			}
 904 
			}
885 
			String emailSubjectTxt = "Products back in stock on Snapdeal "+sdf.format(lastSentInventoryTime);
 905 
			String emailSubjectTxt = "Products back in stock on Snapdeal "+sdf.format(lastSentInventoryTime);
- 
 
 906 
			String text;
886 
			String text = backInStockItems.toString();
 907 
			String tableHeader = "<tr>"
- 
 
 908 
				+ "<td>" + "Product Name" +"</td>"
- 
 
 909 
				+"<td>" + "Item ID" + "</td>"
- 
 
 910 
				+"<td>" + "Old Inventory" + "</td>"
- 
 
 911 
				+"<td>" + "New Inventory" + "</td>"
- 
 
 912 
				+"</tr>";
887 
			if(text.length() > 0){
 913 
			if(backInStockItems.length() > 0){
- 
 
 914 
				text = "<html><table border=\"1\" align=\"center\">"+tableHeader+backInStockItems.toString()+"</table></html>";
888 
				try {
 915 
				try {
889 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
 916 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
890 
				} catch (MessagingException e) {
 917 
				} catch (MessagingException e) {
891 
					e.printStackTrace();
 918 
					e.printStackTrace();
892 
				}
 919 
				}
893 
			}
 920 
			}
894 
			emailSubjectTxt = "Products out of stock on Snapdeal "+sdf.format(lastSentInventoryTime);
 921 
			emailSubjectTxt = "Products out of stock on Snapdeal "+sdf.format(lastSentInventoryTime);
895 
			text = outOfStockItems.toString();
 922 
			if(outOfStockItems.length() > 0){
896 
			if(text.length() > 0){
 923 
				text = "<html><table border=\"1\" align=\"center\">"+tableHeader+backInStockItems.toString()+"</table></html>";
897 
				try {
 924 
				try {
898 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
 925 
					mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
899 
				} catch (MessagingException e) {
 926 
				} catch (MessagingException e) {
900 
					e.printStackTrace();
 927 
					e.printStackTrace();
901 
				}
 928 
				}
Line 906... Line 933...
906 
				mailer.sendSSLMessage(sendTo,"Inventory File",feedresponse, emailFromAddress, password, files);
 933 
				mailer.sendSSLMessage(sendTo,"Inventory File",feedresponse, emailFromAddress, password, files);
907 
			} catch (MessagingException e) {
 934 
			} catch (MessagingException e) {
908 
				e.printStackTrace();
 935 
				e.printStackTrace();
909 
			}
 936 
			}
910 
			 */
 937 
			 */
911 
			inventoryChangeItems.append("\n"+"\n"+feedresponse);
 938 
			if(inventoryChangeItems.length() > 0){
- 
 
 939 
				text = "<html><table border=\"1\" align=\"center\">"+tableHeader+inventoryChangeItems.toString()+"</table></html>";
912 
			try {
 940 
				try {
913 
				mailer.sendSSLMessage(sendTo,"Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis()),inventoryChangeItems.toString(), emailFromAddress, password, new ArrayList<File>());
 941 
					mailer.sendSSLMessage(sendTo,"Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis()),inventoryChangeItems.toString(), emailFromAddress, password, new ArrayList<File>());
914 
			} catch (MessagingException e) {
 942 
				} catch (MessagingException e) {
915 
				e.printStackTrace();
 943 
					e.printStackTrace();
- 
 
 944 
				}
916 
			}
 945 
			}
917 
 
 946 
 
918 
		}
 947 
		}
919 
		else{
 948 
		else{
920 
			try {
 949 
			try {