LEDUAN11 | APP SCRIPT QUẢN LÝ HỌC TẬP

 function Chaylenhall(){ 
  var sf = SpreadsheetApp.openById("1IqcL89JJ1jSD1y5VAXVt7n_fLJj-KgYHkq8Pbp4Jsjw").getSheetByName("User"); 
  var btB3 = sf.getRange("B3").getValue();
  if (btB3 == 'Hoc Tap'){
    Chaylenhhoctap();
  }
  if (btB3 == "Hoc Kem") {
    Chaylenhhockem();
  }
  if (btB3 == "Dung Lop") {
    Chaylenhdunglop();
  }
  if (btB3 == "SheetK") {
    Chaylenhsheetk();
  }  
  if (btB3 == "Tất cả") {
    Chaylenhtheodoihoctap();    
  }  
}

//.....THEO DOI HOC TAP.....//
function Chaylenhtheodoihoctap(){
   Chaylenhhoctap();
   Chaylenhhockem();
   Chaylenhdunglop(); 
}
//.....Hoc Tap.....//
function Chaylenhhoctap(){
  Removelockhoctap();
  Lockhoctap(); 
}

function Removelockhoctap(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("HocTap");     
var protections = sf.getProtections(SpreadsheetApp.ProtectionType.RANGE);
for (var i = 0; i < protections.length; i++) {
  var protection = protections[i];
  if (protection.canEdit()) {
    protection.remove();
}}}

function Lockhoctap(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("HocTap"); 
var sf1 = SpreadsheetApp.openById("1IqcL89JJ1jSD1y5VAXVt7n_fLJj-KgYHkq8Pbp4Jsjw").getSheetByName("DATA");  
var bb1 = sf1.getRange("N2").getValue();  
var AvalsB = sf.getRange("B10:B").getValues().filter(String).length;  
var Lock1 = sf.getRange(AvalsB+7,2,AvalsB+30,6).activate(); 
var protection = sf.protect().addEditor("laos.leduanpoliticalschool@gmail.com");   
    protection.setUnprotectedRanges([(Lock1)]).setDescription('BVHTap');
var protection = Lock1.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditors([bb1]); 
}

//.....Hoc Kem.....//
function Chaylenhhockem(){
  Removelockhockem()
  Lockhockem() 
}

function Removelockhockem(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("HocKem");     
var protections = sf.getProtections(SpreadsheetApp.ProtectionType.RANGE);
for (var i = 0; i < protections.length; i++) {
  var protection = protections[i];
  if (protection.canEdit()) {
    protection.remove();
}}}

function Lockhockem(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("HocKem"); 
var sf1 = SpreadsheetApp.openById("1IqcL89JJ1jSD1y5VAXVt7n_fLJj-KgYHkq8Pbp4Jsjw").getSheetByName("DATA");  
var bb1 = sf1.getRange("S2").getValue();  
var AvalsB = sf.getRange("B10:B").getValues().filter(String).length;  
var Lock1 = sf.getRange(AvalsB+7,2,AvalsB+30,5).activate(); 
var protection = sf.protect().addEditor("laos.leduanpoliticalschool@gmail.com");   
    protection.setUnprotectedRanges([(Lock1)]).setDescription('BVHKem');
var protection = Lock1.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditors([bb1]);   
}

//.....Dung Lop.....//
function Chaylenhdunglop(){
  Removelockdunglop()
  Lockdunglop() 
}

function Removelockdunglop(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("DungLop");     
var protections = sf.getProtections(SpreadsheetApp.ProtectionType.RANGE);
for (var i = 0; i < protections.length; i++) {
  var protection = protections[i];
  if (protection.canEdit()) {
    protection.remove();
}}}

function Lockdunglop(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("DungLop"); 
var sf1 = SpreadsheetApp.openById("1IqcL89JJ1jSD1y5VAXVt7n_fLJj-KgYHkq8Pbp4Jsjw").getSheetByName("DATA");  
var bb1 = sf1.getRange("X2").getValue();  
var AvalsB = sf.getRange("B10:B").getValues().filter(String).length;  
var Lock1 = sf.getRange(AvalsB+7,2,AvalsB+30,4).activate(); 
var Lock2 = sf.getRange(AvalsB+7,7,AvalsB+30,2).activate(); 
var protection = sf.protect().addEditor("laos.leduanpoliticalschool@gmail.com");   
    protection.setUnprotectedRanges([(Lock1),(Lock2)]).setDescription('BVDLop');
var protection = Lock1.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditors([bb1]); 
var protection = Lock2.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditors([bb1]);     
}

//.....SHEET K.....//
function Chaylenhsheetk(){
  Removelocksheetk()
  Locksheetk() 
}

function Removelocksheetk(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("K");     
var protections = sf.getProtections(SpreadsheetApp.ProtectionType.RANGE);
for (var i = 0; i < protections.length; i++) {
  var protection = protections[i];
  if (protection.canEdit()) {
    protection.remove();
}}}

function Locksheetk(){
var sf = SpreadsheetApp.openById("1Szoboq4CiRSo4EjlAVFZQK_xEHbkcuH2EQbdZoKkxtU").getSheetByName("K"); 
var sf1 = SpreadsheetApp.openById("1IqcL89JJ1jSD1y5VAXVt7n_fLJj-KgYHkq8Pbp4Jsjw").getSheetByName("DATA");  
var bb1 = sf1.getRange("AC2").getValue();  
var Lock1 = sf.getRange("M3:M7").activate(); 
var protection = sf.protect().addEditor("laos.leduanpoliticalschool@gmail.com");   
    protection.setUnprotectedRanges([(Lock1)]).setDescription('BVK');
var protection = Lock1.protect();
    protection.removeEditors(protection.getEditors());
    protection.addEditors([bb1]);   
}