/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.controller;

import com.bestray.transtracking.dto.BalanceSheetSearchResultDTO;
import com.bestray.transtracking.dto.ClientCollectionSearchDTO;
import com.bestray.transtracking.dto.JobEntrySearchDTO;
import com.bestray.transtracking.dto.PaymentVoucherSearchDTO;
import com.bestray.transtracking.dto.VehicleExpenseSearchDTO;
import com.bestray.transtracking.service.BalanceSheetService;
import com.bestray.transtracking.service.JobEntryService;
import com.bestray.transtracking.service.TaskService;
import com.bestray.transtracking.service.VehicleMaintenanceService;
import com.bestray.transtracking.service.VehicleService;
import com.bestray.transtracking.service.impl.BalanceSheetServiceImpl;
import com.bestray.transtracking.service.impl.JobEntryServiceImpl;
import com.bestray.transtracking.service.impl.TaskServiceImpl;
import com.bestray.transtracking.service.impl.VehicleMaintenanceServiceImpl;
import com.bestray.transtracking.service.impl.VehicleServiceImpl;
import com.bestray.transtracking.views.VehicleMaster;
import com.bestray.trastrack.domain.ClientCollection;
import com.bestray.trastrack.domain.JobEntry;
import com.bestray.trastrack.domain.VehicleExpenseByParty;
import com.bestray.trastrack.domain.PaymentVoucher;
import com.bestray.trastrack.domain.Task;
import com.bestray.trastrack.domain.VehicleExpense;
import com.bestray.trastrack.domain.VehicleMaintenance;
import com.bestray.trastrack.domain.JobEntryDetails;
import com.bestray.trastrack.domain.VehicleExpenseDetails;
import com.bestray.trastrack.domain.PaymentDetailsByParty;
import com.bestray.trastrack.domain.ClientCollectionDetails;
import com.bestray.trastrack.domain.Vehicle;
import java.util.List;
import java.util.Vector;

/**
 *
 * @author Girija Sahu
 */
public class BalanceSheetController {
    private BalanceSheetService balanceservice;
     private JobEntryService jeService; 
     VehicleMaintenanceService maintenanceService;
     private TaskService taskService;
     private VehicleService vehicleService;
     
    public BalanceSheetController(){
       balanceservice = new BalanceSheetServiceImpl();
      maintenanceService = new VehicleMaintenanceServiceImpl();
      taskService = new TaskServiceImpl();
      vehicleService = new VehicleServiceImpl();
        //jeService = new JobEntryServiceImpl();
    }

    public JobEntryDetails getSearchResults(JobEntrySearchDTO search) {
       
        List<JobEntry> JobEntrylist = balanceservice.getSearchResult(search);
        Double totalAmount = 0.0;
          JobEntryDetails jobDetail = new JobEntryDetails();
          
        Vector<Vector<String>> returnList = new Vector<Vector<String>>();
          
           for(JobEntry record:JobEntrylist){
             
              Vector<String> jentry = new Vector<String>();
              //jentry.add(String.valueOf(record.getId()));
              jentry.add(String.valueOf(record.getJob_date())); 
              Vehicle v = vehicleService.getVehicleRegistrationDetails(record.getVehicle_number_id());
              jentry.add(v.getVehicle_number()); 
              jentry.add(record.getFrom_location()+" - "+record.getTo_location());
              jentry.add(String.valueOf(record.getGoods_quantity()));
              jentry.add(String.valueOf(record.getTotal_receivable_amount()));
               totalAmount+=(record.getTotal_receivable_amount() != null)?record.getTotal_receivable_amount():0.0;
              returnList.add(jentry);
              }
            jobDetail.setReturnList(returnList);
            jobDetail.setTotalAmount(totalAmount);
               return jobDetail;
       
    }

    
    public ClientCollectionDetails getCollectionSearchResults(ClientCollectionSearchDTO search2) {
        
        ClientCollectionDetails collectionDetails = new ClientCollectionDetails();
        List<ClientCollection> collectionlist = balanceservice.getCollectionSearchResult(search2);
          Vector<Vector<String>> returnList = new Vector<Vector<String>>();
          Double totalAmount = 0.0;
           for(ClientCollection record:collectionlist){
             
              Vector<String> jentry = new Vector<String>();
              //jentry.add(String.valueOf(record.getId()));
              jentry.add(String.valueOf(record.getPayment_date())); 
              jentry.add(String.valueOf(record.getAmount()));
              jentry.add(String.valueOf(record.getComment1()));
              totalAmount+=(record.getAmount() != null)?record.getAmount():0.0;
              returnList.add(jentry);
              }
           collectionDetails.setReturnList(returnList);
           collectionDetails.setTotalAmount(totalAmount);
               return collectionDetails;
    }

    public VehicleExpenseByParty getExpenseSearchResults(VehicleExpenseSearchDTO expensesearch) {
        List<VehicleExpenseDetails> expenselist = balanceservice.getExpenseSearchResult(expensesearch);
        
        VehicleExpenseByParty finalexpanse = new VehicleExpenseByParty();
          Vector<Vector<String>> returnList = new Vector<Vector<String>>();
           Double totalAmount = 0.0;
           for(VehicleExpenseDetails record:expenselist){
              
               Vector<String> jentry = new Vector<String>();
              
              jentry.add(String.valueOf(record.getExpenseDate())); 
              jentry.add(record.getTaskName());
              jentry.add(String.valueOf(record.getAmount()));
             
              totalAmount+=(record.getAmount() != null)?record.getAmount():0.0;
                
              returnList.add(jentry);
              }
           finalexpanse.setTotalExpenseAmount(totalAmount);
           finalexpanse.setReturnList(returnList);
           
               return finalexpanse;
    }

    public PaymentDetailsByParty getPaymentSearchResults(PaymentVoucherSearchDTO paymentsearch) {
        List<PaymentVoucher> collectionlist = balanceservice.getPaymentSearchResult(paymentsearch);
        
          Vector<Vector<String>> returnList = new Vector<Vector<String>>();
          PaymentDetailsByParty partyPayment = new PaymentDetailsByParty();
          Double paidAmt = 0.0;
           for(PaymentVoucher record:collectionlist){
             
              Vector<String> jentry = new Vector<String>();
              //jentry.add(String.valueOf(record.getId()));
              jentry.add(String.valueOf(record.getPayment_date())); 
              jentry.add(String.valueOf(record.getAmount_paid()));
              paidAmt+=(record.getAmount_paid() != null)?record.getAmount_paid():0.0;
              returnList.add(jentry);
              }
           partyPayment.setReturnList(returnList);
           partyPayment.setTotalAmount(paidAmt);
               return partyPayment;
    }

    
    
    
}