Most and longest running software developed for consumerfed

Dear readers,

It has been two and a half years since the application is launched at consumerfed kozhikode region and successfully running in the region at 40 trivenis including mobile , godown, neethi medicasl sections and liquor shop.
The whole credit for developing the software goes to the IT section regional office ( Management trainees) But now consumerfed is planning to reduce the size of Management trainees

A great that to I T Section kozhikode.


The project was launched on March 2015 and last updated on September 2017. Report to mobiles are also available now. Backup s are automated

E mail report

footer

Tracking the sales , subsidy monitoring, tracking hardware details are other key features of the application. Reports in html , pdf formats are available, video tutorials are available in youtube channel.


You can contact us on 0091-8218808029

Join us at linkedin  follow us  Hangout group

Mobile phone cover - Buy one Hurry !!! 

Attendance Tracking System online

Attendance Google Form

Source code

function consolidatingAttendance(){

  var attendanceSpreadSheet = SpreadsheetApp.openById("consumerfedAttendanceSheet");

  var attendanceSheet = attendanceSpreadSheet.getSheetByName("ATTENDANCE");
  var consolidationSheet = attendanceSpreadSheet.getSheetByName("CONSOLIDATION");

  var startRowAttendance = consolidationSheet.getRange("H1").getValue();
  var lastRowAttendance = attendanceSheet.getLastRow();
  var lastRowOfAttendanceArray = lastRowAttendance - startRowAttendance - 1;

  var branchListAS = attendanceSheet.getRange(startRowAttendance,2,lastRowOfAttendanceArray,1).getValues();
  var empListAS = attendanceSheet.getRange(startRowAttendance,3,lastRowOfAttendanceArray,1).getValues();
  var attndListAS = attendanceSheet.getRange(startRowAttendance,4,lastRowOfAttendanceArray,1).getValues();

  //Logger.log(branchListAS);
  var currentAttndRowPstn = startRowAttendance;

  //var branchListCS = consolidationSheet.getRange(1,1,consolidationSheet.getLastRow(),1).getValues();
 // Logger.log(branchListCS);

  //var branchListCS = consolidationSheet.getRange(1,1,consolidationSheet.getLastRow(),1).getValues();
  //var empListCS = consolidationSheet.getRange(1,2,consolidationSheet.getLastRow(),1).getValues();

  Logger.log( " Len :"+branchListAS.length);

  for(var rowCount = 0; rowCount < branchListAS.length; rowCount++){
    //Logger.log(currentAttndRowPstn+" , "+branchListAS[rowCount]+" , "+empListAS[rowCount]+" , "+attndListAS[rowCount]);
 
          var branchListCS = consolidationSheet.getRange(1,1,consolidationSheet.getLastRow(),1).getValues();
          var empListCS = consolidationSheet.getRange(1,2,consolidationSheet.getLastRow(),1).getValues();
       
          //Logger.log(" B :"+branchListCS[0]);
       
          var lastRowCS = consolidationSheet.getLastRow();
          var lastConsolidationRow = lastRowCS + 1;
       
          var branchNameAS = branchListAS[rowCount].toString();
          var employeeNameAS = empListAS[rowCount].toString();
          var attendanceTypeAS = attndListAS[rowCount].toString();  // present,onduty etc
       
       
          currentAttndRowPstn = currentAttndRowPstn + 1;
          consolidationSheet.getRange("H1").setValue(currentAttndRowPstn);
       
       
          var isInserted = 1;
       
          for(var rowCS = 0; rowCS < branchListCS.length; rowCS++){
       
                var attendanceType = attendanceTypeAS;
                var branchNameCS = branchListCS[rowCS].toString();
                var employeeNameCS = empListCS[rowCS].toString();
             
                var as = branchNameAS.concat(employeeNameAS);
                var cs = branchNameCS.concat(employeeNameCS);
             
                var value = as.localeCompare(cs);
             
                //Logger.log("v :"+value +"as :"+as +"cs :"+cs);
             
                if(value == 0){
               
                  var row = rowCS + 1;
                  var choose = attendanceType;
                  attendanceType = "";
               
                  //Logger.log(" A :"+attendanceType+" R :"+row );
               
                  switch(choose){
                         case "PRESENT":
                               value = consolidationSheet.getRange("C"+row).getValue();
                               consolidationSheet.getRange("C"+row).setValue(value+1);
                               consolidationSheet.getRange("I"+row).setValue(new Date());
                               attendanceType = "";
                              // Logger.log('----'+value);
                               break;
                        case "FULL DAY(L)":
                               value = consolidationSheet.getRange("D"+row).getValue();
                               consolidationSheet.getRange("D"+row).setValue(value+1);
                               consolidationSheet.getRange("I"+row).setValue(new Date());
                               attendanceType = "";
                               //Logger.log('----'+value);
                               break;
                        case "HALF DAY - MORNING(L)":
                               value = consolidationSheet.getRange("E"+row).getValue();
                               consolidationSheet.getRange("E"+row).setValue(value+1);
                               consolidationSheet.getRange("I"+row).setValue(new Date());
                               attendanceType = "";
                               //Logger.log('----'+value);
                                break;
                         case "HALF DAY - AFTER NOON(L)":
                               value = consolidationSheet.getRange("F"+row).getValue();
                               consolidationSheet.getRange("F"+row).setValue(value+1);
                               consolidationSheet.getRange("I"+row).setValue(new Date());
                               attendanceType = "";
                               //Logger.log('----'+value);
                                break;
                        case "ON DUTY":
                               value = consolidationSheet.getRange("G"+row).getValue();
                               consolidationSheet.getRange("G"+row).setValue(value+1);
                               consolidationSheet.getRange("I"+row).setValue(new Date());
                               attendanceType = "";
                               //Logger.log('----'+value);
                              break;
                        default:    
                             }
                     
                        isInserted = 0;
                        attendanceType = "";
                        branchNameAS = "";
                        employeeNameAS = "";
                     
                 
                      }
                   
                      else{
                     
                        if(attendanceType.length > 0) {
                     
                        var choose = attendanceType;
                        consolidationSheet.getRange("A"+lastConsolidationRow).setValue(branchNameAS);
                        consolidationSheet.getRange("B"+lastConsolidationRow).setValue(employeeNameAS);
                     
                        Logger.log(" Before switch : "+choose);
                     
                        switch(choose){
                       
                     
                        case "FULL DAY(L)":
                               consolidationSheet.getRange("D"+lastConsolidationRow).setValue(1);
                               consolidationSheet.getRange("C"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("E"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("F"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("G"+lastConsolidationRow).setValue(0);
                        break;
                        case "HALF DAY - MORNING(L)":
                               consolidationSheet.getRange("E"+lastConsolidationRow).setValue(1);
                               consolidationSheet.getRange("C"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("D"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("F"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("G"+lastConsolidationRow).setValue(0);
                        break;
                        case "HALF DAY - AFTER NOON(L)":
                               consolidationSheet.getRange("F"+lastConsolidationRow).setValue(1);
                               consolidationSheet.getRange("C"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("E"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("D"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("G"+lastConsolidationRow).setValue(0);
                        break;
                        case "ON DUTY":
                               consolidationSheet.getRange("G"+lastConsolidationRow).setValue(1);
                               consolidationSheet.getRange("C"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("E"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("F"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("D"+lastConsolidationRow).setValue(0);
                        break;
                        case "PRESENT":
                               consolidationSheet.getRange("C"+lastConsolidationRow).setValue(1);
                               consolidationSheet.getRange("D"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("E"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("F"+lastConsolidationRow).setValue(0);
                               consolidationSheet.getRange("G"+lastConsolidationRow).setValue(0);
                        break;
                        default :
                               Logger.log("test : "+attendanceType);
                               var values = [[ "0", "0", "0" , "0", "0"]];
                               consolidationSheet.getRange("C"+lastConsolidationRow+":G"+lastConsolidationRow).setValue(values);
                           
                        } //end switch
                     
                       }// if attendanceType
                     
                       // consolidationSheet.getRange("I"+lastConsolidationRow).setValue(new Date());
                     
                } //end if - else
             
                  //Logger.log(" R: "+rowCount+" isInserted "+isInserted );
           
   
           
          }
 
 
  }


  }

Link to attendance form


http://javabelazy.blogspot.in/

Regional Office - Consumerfed Information Technology Section Kozhikode

Consumerfed Regional office kozhikode Region IT Section

https://consumerfed.net/triveni-supermarket/

സീസണൽ റിപ്പോർട്

റിപ്പോർട് മൊബൈൽ ലഭിക്കുവാൻ സബ്സ്ക്രൈബ് ചെയുക 

സീസണൽ റിപ്പോർട്

Contact us @ 8281808025/9

Thanks to +Consumerfed IT Division   +Consumerfed  +deepajayaprakash payyanakkal  for their supports

Downloads

1. English to Malayalam converting sofware maduri download
2. Lenovo think centre edge video driver download
3. TVS MSP 250 STAR Win7 32bit download
4. Windows rar extractor win rar 32 bit download
5. Transfer of hardware parts image file download
6. Transfer of hardware parts PDF file download
7. Excel Templates
8. Download attendance bat file(rar)
9. Download Day to day work tracking software for cfed

Regional Office Kozhikode

1. Taking reports using pivot table in ms office excel
2. How to share an microsoft office excel to work multiple user simultaneously
3. consolidate many table to one using consolidate option in ms office excel
4. Working with pivot table in microsoft office excel 2010
5. working with share point in microsoft office
6. create a internal chat application in organization
7. created an online attendance tracking google spreadsheet application
8. created an online sales google spreadsheet application for consumerfed
9. created an online hardware register for itsection regional office kozhikode
10. created an Employee Management System for Consumerfed Regional Office kozhikode Spring MVC
11. Application for preparing budget