app2.js

setTimeout(() => {
  const loader = document.getElementById("waitArea");
  loader.style.display = "none";
    document.getElementById("allContent").style.visibility="visible";
}, 7050);
var options = document.getElementById("people");
var optionsEng = document.getElementById("peopleEng");
var theImportantT2DURL="https://script.google.com/macros/s/AKfycbzcWW--rxYPZWO-fogfe6Frn1YXVejatzNlBU53UMNOToe50OFC-cv_ndXojlLOePU4/exec";
var url =
  "https://script.google.com/macros/s/AKfycbxDcej67zrhC5zOxbGN76qFBZc3AWbP4UUhexUqPRnzN79Lb5ZmTl5PMgYNFihoXXl3Kg/exec";
var urlEng="https://script.google.com/macros/s/AKfycbwif1D1ZdoI1iYaL2Hya5Jke8UIFaoPxMo2Jkvd3cNytK35UIGbJZ0NKwhiYJQgana8-A/exec";
var newPerson = {};
var selectedPerson = {};
var allPeople = [];
var rowCount = 2;
var size = 0;
var personOption;
var allChains = [];
var newChain = {};
var currChain = {};
var descLines1=[];
var descLines2=[];
var linesInFiveHeb=[];
var linesInFullVideoHeb=[];
var linesInPrepareTalkHeb=[];
var linesInExplainChainHeb=[];
var linesInShortHeb=[];
var linesInSoundHeb=[];
var linesInPlaylistFiveHeb=[];
var linesInPlaylistFullHeb=[];
var linesInLivePostHeb=[];
var linesInFiveLiveHeb=[];
var linesInFullVideoLiveHeb=[];
var linesInEventHeb=[];
var linesInFiveEng=[];
var linesInFullVideoEng=[];
var linesInPrepareTalkEng=[];
var linesInExplainChainEng=[];
var linesInShortEng=[];
var linesInSoundEng=[];
var linesInPlaylistFiveEng=[];
var linesInPlaylistFullEng=[];
var linesInLivePostEng=[];
var linesInFiveLiveEng=[];
var linesInFullVideoLiveEng=[];
var linesInEventEng=[];
var currLang="";
var titles={
     fiveHeb:"",
     fullVideoHeb:"",
     prepareTalkHeb:"",
     explainChainHeb:"",
     shortHeb:"",
     soundHeb:"",
     playlistFiveHeb:"",
     playlistFullHeb:"",
     livePostHeb:"",
     fiveLiveHeb:"",
     fullVideoLiveHeb:"",
     eventHeb:"",
    
     fiveEng:"",
     fullVideoEng:"",
     prepareTalkEng:"",
     explainChainEng:"",
     shortEng:"",
     soundEng:"",
     playlistFiveEng:"",
     playlistFullEng:"",
     livePostEng:"",
     fiveLiveEng:"",
     fullVideoLiveEng:"",
     eventEng:"",
};
var chainDataURL =
  "https://script.google.com/macros/s/AKfycbz7IgSM1Rhei0PPSgEHwxD_YHtyevYhZt32Mje9asUeGE20_J8a59XYw0xNFJMxjDKXKA/exec";
getData();
getDataEng();
getTitlesData();
getDescData();
getChainData();

function getDescData(){
    fetch(theImportantT2DURL)
    .then((res) => {
      return res.json();
    })
    .then((json) => {
         json.data.heb.forEach((ele) => {         
             descLines1.push(ele.lineindescription);
             linesInFiveHeb.push(ele.five);
             linesInFullVideoHeb.push(ele.fullvideo);
             linesInPrepareTalkHeb.push(ele.preparetalk);
             linesInExplainChainHeb.push(ele.explainchain);
             linesInShortHeb.push(ele.short);
             linesInSoundHeb.push(ele.sound);
             linesInPlaylistFiveHeb.push(ele.playlistfive);
             linesInPlaylistFullHeb.push(ele.playlistfull);
             linesInLivePostHeb.push(ele.livepost);
             linesInFiveLiveHeb.push(ele.fivelive);
             linesInFullVideoLiveHeb.push(ele.fullvideolive);
             linesInEventHeb.push(ele.event);
         })
            json.data.eng.forEach((ele) => {         
             descLines2.push(ele.lineindescription);
             linesInFiveEng.push(ele.five);
             linesInFullVideoEng.push(ele.fullvideo);
             linesInPrepareTalkEng.push(ele.preparetalk);
             linesInExplainChainEng.push(ele.explainchain);
             linesInShortEng.push(ele.short);
             linesInSoundEng.push(ele.sound);
             linesInPlaylistFiveEng.push(ele.playlistfive);
             linesInPlaylistFullEng.push(ele.playlistfull);
             linesInLivePostEng.push(ele.livepost);
             linesInFiveLiveEng.push(ele.fivelive);
             linesInFullVideoLiveEng.push(ele.fullvideolive);
             linesInEventEng.push(ele.event);
         })
        
       
    })
    
}
function getTitlesData(){
    fetch(theImportantT2DURL)
    .then((res) => {
      return res.json();
    })
    .then((json) => {
         json.data.titles.forEach((ele) => { 
             if(ele.language==="hebrew"){
                 titles.fiveHeb=ele.five,
                 titles.fullVideoHeb=ele.fullvideo,
                 titles.prepareTalkHeb=ele.preparetalk,
                titles.explainChainHeb=ele.explainchain,
                titles.shortHeb=ele.short,
                titles.soundHeb=ele.sound,
                titles.playlistFiveHeb=ele.playlistfive,
                titles.playlistFullHeb=ele.playlistfull,
                titles.livePostHeb=ele.livepost,
                titles.fiveLiveHeb=ele.fivelive,
                titles.fullVideoLiveHeb=ele.fullvideolive,
                titles.eventHeb=ele.event
            }
             if(ele.language==="english"){
                 titles.fiveEng=ele.five,
                 titles.fullVideoEng=ele.fullvideo,
                 titles.prepareTalkEng=ele.preparetalk,
                titles.explainChainEng=ele.explainchain,
                titles.shortEng=ele.short,
                titles.soundEng=ele.sound,
                titles.playlistFiveEng=ele.playlistfive,
                titles.playlistFullEng=ele.playlistfull,
                titles.livePostEng=ele.livepost,
                titles.fiveLiveEng=ele.fivelive,
                titles.fullVideoLiveEng=ele.fullvideolive,
                titles.eventEng=ele.event
             }
         })
        console.log(titles);
    })
    
}
function getDataEng(){
    fetch(urlEng)
    .then((res) => {
      return res.json();
    })
    .then((json) => {
      json.data.forEach((ele) => {
        newPerson = {
          name: ele.name,
          interviewerName: ele.interviewername,
          chain: ele.chain,
           email: ele.email,
           guestphone: ele.phone,
          interphone: ele.interviewerphone,
          topicOfStory: ele.topicofstory,
          order: ele.order,
          fullVideo: ele.linkfull,
          fiveVideo: ele.linkfive,
          date: "",
            hour:"",
          explainVideo: ele.linkexplain,
          prepTalk: ele.preptalk,
          abouttheguest: ele.abouttheguestone,
          facebook: ele.facebook,
          instagram: ele.instagram,
          tiktok: ele.tiktok,
          sites: ele.othersites + " " + ele.moreothersites,
            id: ele.id,
            ide:ele.ide,
          row: rowCount,
        };

        if (ele.fixedname !== "") newPerson.name = ele.fixedname;
        if (ele.fixedinterviewername !== "")
          newPerson.interviewerName = ele.fixedinterviewername;
        if (ele.fixedchain !== "") newPerson.chain = ele.fixedchain;
        newPerson.chain = fixChain(newPerson.chain);
        if (ele.fixedemail !== "") newPerson.email = ele.fixedemail;
        if (ele.fixedphone !== "") newPerson.guestphone = ele.fixedphone;
        if (ele.fixedinterviewerphone !== "")
          newPerson.interphone = ele.fixedinterviewerphone;
        if (ele.fixedtopicofstory !== "")
          newPerson.topicOfStory = ele.fixedtopicofstory;
        if (newPerson.abouttheguest === "") {
          if (ele.abouttheguesttwo !== "") newPerson.abouttheguest = ele.abouttheguesttwo;
        }
        if (ele.fixedabouttheguest !== "")
          newPerson.abouttheguest = ele.fixedabouttheguest;
        if (ele.recordingdate !== "")
          newPerson.date = changeTimeZone(new Date(ele.recordingdate), 'Asia/Jerusalem');
       if (ele.fixedrecordingdate !== "")
          newPerson.date = changeTimeZone(new Date(ele.fixedrecordingdate), 'Asia/Jerusalem');
        if (ele.recordinghour !== "")
          newPerson.hour = changeTimeZone(new Date(ele.recordinghour), 'Asia/Jerusalem');
        if (ele.fixedrecordinghour !== "")
          newPerson.hour = changeTimeZone(new Date(ele.fixedrecordinghour), 'Asia/Jerusalem');
        if (newPerson.fullVideo === "שרשרת קצרה") newPerson.fullVideo = "";
        allPeople.push(newPerson);
        personOption = document.createElement("option");
        personOption.value = newPerson.name + " + " + newPerson.chain;
        personOption.id = rowCount;
        if (ele.fixedrecordingdate!=="ללא תאריך"&&(newPerson.name !== "" || newPerson.chain !== "")) {
          console.log(allPeople[size]);
          optionsEng.append(personOption);
        }
        rowCount++;
        size++;
      });
    });
}
function getData() {
  fetch(url)
    .then((res) => {
      return res.json();
    })
    .then((json) => {
      json.data.forEach((ele) => {
        newPerson = {
          name: ele.name,
          interviewerName: ele.interviewername,
          chain: ele.chain,
          email: ele.email,
           guestphone: ele.phone,
          interphone: ele.interviewerphone,
          topicOfStory: ele.topicofstory,
          message: ele.subtitle,
            virtue: ele.virtue,
          order: ele.order,
          fullVideo: ele.linkfull,
          fiveVideo: ele.linkfive,
          date: "",
            hour:"",
          explainVideo: ele.linkexplain,
          prepTalk: ele.preptalk,
          abouttheguest: ele.abouttheguest,
          facebook: ele.facebook,
          instagram: ele.instagram,
          tiktok: ele.tiktok,
          sites: ele.othersites + " " + ele.moreothersites,
            id: ele.id,
            ide:ele.id,
          row: rowCount,
        };

        if (ele.fixedname !== "") newPerson.name = ele.fixedname;
        if (ele.fixedinterviewername !== "")
          newPerson.interviewerName = ele.fixedinterviewername;
        if (newPerson.chain === "") {
          if (ele.chaintwo !== "") newPerson.chain = ele.chaintwo;
          if (ele.chainthree !== "") newPerson.chain = ele.chainthree;
          if (ele.chainfour !== "") newPerson.chain = ele.chainfour;
        }
        if (ele.fixedchain !== "") newPerson.chain = ele.fixedchain;
        newPerson.chain = fixChain(newPerson.chain);
        if (ele.fixedemail !== "") newPerson.email = ele.fixedemail;
        if (ele.fixedphone !== "") newPerson.guestphone = ele.fixedphone;
        if (ele.fixedinterviewerphone !== "")
          newPerson.interphone = ele.fixedinterviewerphone;
        if (ele.fixedtopicofstory !== "")
          newPerson.topicOfStory = ele.fixedtopicofstory;
        if (ele.fixedabouttheguest !== "")
          newPerson.abouttheguest = ele.fixedabouttheguest;
        if (ele.recordingdate !== "")
          newPerson.date = changeTimeZone(new Date(ele.recordingdate), 'Asia/Jerusalem');
       if (ele.fixedrecordingdate !== "")
          newPerson.date = changeTimeZone(new Date(ele.fixedrecordingdate), 'Asia/Jerusalem');
        if (ele.recordinghour !== "")
          newPerson.hour = changeTimeZone(new Date(ele.recordinghour), 'Asia/Jerusalem');
        if (ele.fixedrecordinghour !== "")
          newPerson.hour = changeTimeZone(new Date(ele.fixedrecordinghour), 'Asia/Jerusalem');
        if (newPerson.fullVideo === "שרשרת קצרה") newPerson.fullVideo = "";
        if (ele.fixedsubtitle !== "")
            newPerson.message = ele.fixedsubtitle;
        if (ele.fixedvirtue !== "")
            newPerson.virtue = ele.fixedvirtue;
        allPeople.push(newPerson);
        personOption = document.createElement("option");
        personOption.value = newPerson.name + " + " + newPerson.chain;
        personOption.id = rowCount;
        if (ele.fixedrecordingdate!=="ללא תאריך"&&(newPerson.name !== "" || newPerson.chain !== "")) {
          console.log(allPeople[size]);
          options.append(personOption);
        }
        rowCount++;
        size++;
      });
    });
}
function getChainData() {
  fetch(chainDataURL)
    .then((res) => {
      return res.json();
    })
    .then((json) => {
      json.data.chains.forEach((ele) => {
        newChain = {
          name: ele.name,
          altName: ele.othername,
          playlist: ele.playlist,
          description: ele.description,
          about:ele.about,
          participants:ele.participants,
        };
        allChains.push(newChain);
      });
    });
}
function submitData() {
  for (var i = 0; i < allPeople.length; i++) {
    var nameAndChain = document.getElementById("peopleList").value.split(" + ");
    if (
      allPeople[i].name === nameAndChain[0] &&
      allPeople[i].chain === nameAndChain[1]
    ) {
      console.log("row num:" + allPeople[i].row);
      selectedPerson = allPeople[i];
      if (selectedPerson.chain !== "") {
        for (var j = 0; j < allChains.length; j++) {
          if (
            selectedPerson.chain === allChains[j].name ||
            selectedPerson.chain === allChains[j].altName
          ) {
            currChain = allChains[j];
            console.log(currChain);
            selectedPerson.chain = allChains[j].name;
            if (
              endsWithNumber(selectedPerson.chain) &&
              selectedPerson.chain === allChains[j].name
            ) {
              selectedPerson.chain = allChains[j].altName;
            }
            if (
              endsWithNumber(selectedPerson.chain) &&
              selectedPerson.chain === allChains[j].altName
            ) {
              selectedPerson.chain = allChains[j].name;
            }
          }
        }
      }
    }
  }

  document.getElementById("order").value = selectedPerson.order;
  document.getElementById("linkToFive").value = selectedPerson.fiveVideo;
  document.getElementById("linkToFull").value = selectedPerson.fullVideo;
  document.getElementById("linkToPrep").value = selectedPerson.prepTalk;
  document.getElementById("linkToExplain").value = currChain.about;
  document.getElementById("linkToPlaylist").value = currChain.playlist;
  
}
function submitDataEng() {
  for (var i = 0; i < allPeople.length; i++) {
    var nameAndChain = document.getElementById("peopleListEng").value.split(" + ");
    if (
      allPeople[i].name === nameAndChain[0] &&
      allPeople[i].chain === nameAndChain[1]
    ) {
      console.log("row num:" + allPeople[i].row);
      selectedPerson = allPeople[i];
      if (selectedPerson.chain !== "") {
        for (var j = 0; j < allChains.length; j++) {
          if (
            selectedPerson.chain === allChains[j].name ||
            selectedPerson.chain === allChains[j].altName
          ) {
            currChain = allChains[j];
            console.log(currChain);
            selectedPerson.chain = allChains[j].name;
            if (
              endsWithNumber(selectedPerson.chain) &&
              selectedPerson.chain === allChains[j].name
            ) {
              selectedPerson.chain = allChains[j].altName;
            }
            if (
              endsWithNumber(selectedPerson.chain) &&
              selectedPerson.chain === allChains[j].altName
            ) {
              selectedPerson.chain = allChains[j].name;
            }
          }
        }
      }
    }
  }

  document.getElementById("order").value = selectedPerson.order;
  document.getElementById("linkToFive").value = selectedPerson.fiveVideo;
  document.getElementById("linkToFull").value = selectedPerson.fullVideo;
  document.getElementById("linkToPrep").value = selectedPerson.prepTalk;
  document.getElementById("linkToExplain").value = currChain.about;
  document.getElementById("linkToPlaylist").value = currChain.playlist;
  
}
function reset() {
  document.getElementById("order").value = "";
  document.getElementById("linkToFull").value = "";
  document.getElementById("linkToPrep").value = "";
  document.getElementById("linkToPlaylist").value = "";
  document.getElementById("linkToExplain").value = "";
  document.getElementById("linkToFive").value = "";
     document.getElementById("titleCopy").innerHTML="להעתקת הכותרת";
   document.getElementById("textCopy").innerHTML="להעתקת התיאור";
}
function copycat(id) {
    
  var text = document.getElementById(id).innerText;
    while(text.includes("_שורה_ריקה_")){
        text=text.replace("_שורה_ריקה_","");
    }
  var elem = document.createElement("textarea");
  document.body.appendChild(elem);
  elem.value = text;
  elem.select();
  document.execCommand("copy");
  document.body.removeChild(elem);
  document.getElementById(id+"Copy").innerHTML="הועתק";
}
function fixDate(str) {
  var year = str.getFullYear();
  var month = str.getMonth() + 1;
  var day = str.getDate();
  return day + "/" + month + "/" + year;
}
function fixHour(str) {
  var hour = str.getHours();
  var minute = str.getMinutes();
 if (minute < 10){
     return hour+":0" +minute;
 }
 return hour+":"+minute;
}
function fixTags(str){

    while (str.includes(".")) {
        str = str.replace(".", "_");
    }
    while (str.includes(" ")) {
        str = str.replace(" ", "_");
    }
    return str;
}
function fixChain(chain) {
  var splittedChain; //
  if (chain.includes(" (") || chain.includes("-")) {
    splittedChain = chain.split(" (");
    var moresplitted;
    if (splittedChain[0].includes("-")) {
      moresplitted = splittedChain[0].split("-");
      return moresplitted[1].trim();
    }
    return splittedChain[0].trim();
  }
  return chain;
}
function submit() {
    document.getElementById("titleCopy").innerHTML="להעתקת הכותרת";
   document.getElementById("textCopy").innerHTML="להעתקת התיאור";
    var type="five";
    var lang="heb";
     if (document.getElementById("tinyHeb").checked) 
         {
             type="short";
             lang="heb";
         }
        
     if (document.getElementById("shortHeb").checked) 
       
    {
             type="five";
             lang="heb";
         }
    if(document.getElementById("longHeb").checked)
    {
             type="fullVideo";
             lang="heb";
         }
    if(document.getElementById("soundHeb").checked)
    
    {
             type="sound";
             lang="heb";
         }
    if(document.getElementById("preHeb").checked)
        
    {
             type="prepareTalk";
             lang="heb";
         }
    if(document.getElementById("expHeb").checked)
        
    {
             type="explainChain";
             lang="heb";
         }
    if(document.getElementById("playlistFiveHeb").checked)
    {
             type="playlistFive";
             lang="heb";
         }
    if(document.getElementById("playlistFullHeb").checked)
    {
             type="playlistFull";
             lang="heb";
         }
    if(document.getElementById("livePostHeb").checked)
    {
             type="livePost";
             lang="heb";
         }
    if(document.getElementById("fullVideoLiveHeb").checked)
    {
             type="fullVideoLive";
             lang="heb";
         }
     if(document.getElementById("fiveLiveHeb").checked)
    {
             type="fiveLive";
             lang="heb";
         }
      if(document.getElementById("eventHeb").checked)
    {
             type="event";
             lang="heb";
         }
     if (document.getElementById("tinyEng").checked) 
    {
             type="short";
             lang="eng";
         }
     if (document.getElementById("shortEng").checked) 
    {
             type="five";
             lang="eng";
         }
    if(document.getElementById("longEng").checked)
    {
             type="fullVideo";
             lang="eng";
         }
    if(document.getElementById("soundEng").checked)
    {
             type="sound";
             lang="eng";
         }
    if(document.getElementById("preEng").checked)
    {
             type="prepareTalk";
             lang="eng";
         }
    if(document.getElementById("expEng").checked)
    {
             type="explainChain";
             lang="eng";
         }
    if(document.getElementById("playlistFiveEng").checked)
    {
             type="playlistFive";
             lang="eng";
         }
    if(document.getElementById("playlistFullEng").checked)
    {
             type="playlistFull";
             lang="eng";
         }
    if(document.getElementById("livePostEng").checked)
    {
             type="livePost";
             lang="eng";
         }
    if(document.getElementById("fullVideoLiveEng").checked)
    {
             type="fullVideoLive";
             lang="eng";
         }
    if(document.getElementById("fiveLiveEng").checked)
    {
             type="fiveLive";
             lang="eng";
         }
    if(document.getElementById("eventEng").checked)
    {
             type="event";
             lang="eng";
         }
    showText(type,lang);
    fixTitle(type,lang);
}
function showText(type,lang){
    currLang=lang;
    var testDiv = document.getElementById("text");
    removeAllChildNodes(testDiv);
    console.log("in "+type+":");
    var currLine;
    if(lang==="heb"){
        document.getElementById("text").style.textAlign="right";
        document.getElementById("text").style.direction="rtl";
        document.getElementById("title").style.textAlign="right";
        document.getElementById("title").style.direction="rtl";
        for(var i=0;i<descLines1.length;i++){
            currLine=descLines1[i];
            currLine=swapWithData(currLine);
            if(
                (type==="five"&&linesInFiveHeb[i]==="v")||
                (type==="fullVideo"&&linesInFullVideoHeb[i]==="v")||
                (type==="prepareTalk"&&linesInPrepareTalkHeb[i]==="v")||
                (type==="explainChain"&&linesInExplainChainHeb[i]==="v")||
                (type==="short"&&linesInShortHeb[i]==="v")||
                (type==="sound"&&linesInSoundHeb[i]==="v")||
                (type==="playlistFive"&&linesInPlaylistFiveHeb[i]==="v")||
                (type==="playlistFull"&&linesInPlaylistFullHeb[i]==="v")||
                (type==="livePost"&&linesInLivePostHeb[i]==="v")||
                (type==="fullVideoLive"&&linesInFullVideoLiveHeb[i]==="v")||
                (type==="fiveLive"&&linesInFiveLiveHeb[i]==="v")||
                (type==="event"&&linesInEventHeb[i]==="v")
              ){
                    if(currLine!==""&&currLine!=="_שורה_ריקה_"){
                        console.log(currLine);
                        var testH4 = document.createElement("h4");
                        testH4.innerHTML = currLine;
                        testDiv.append(testH4);
                    }
                    if(currLine==="_שורה_ריקה_"){
                        console.log(currLine);
                      var testH4 = document.createElement("h4");
                        testH4.innerText = "<br>";
                        testH4.innerHTML = currLine;
                        testH4.style.color="white";
                        testDiv.append(testH4);
                    }

            }
            currLine="";
        }
    }
    if(lang==="eng"){
        document.getElementById("text").style.textAlign="left";
        document.getElementById("text").style.direction="ltr";
        document.getElementById("title").style.textAlign="left";
        document.getElementById("title").style.direction="ltr";
        for(var i=0;i<descLines2.length;i++){
            currLine=descLines2[i];
            currLine=swapWithData(currLine);
            if(
                (type==="five"&&linesInFiveEng[i]==="v")||
                (type==="fullVideo"&&linesInFullVideoEng[i]==="v")||
                (type==="prepareTalk"&&linesInPrepareTalkEng[i]==="v")||
                (type==="explainChain"&&linesInExplainChainEng[i]==="v")||
                (type==="short"&&linesInShortEng[i]==="v")||
                (type==="sound"&&linesInSoundEng[i]==="v")||
                (type==="playlistFive"&&linesInPlaylistFiveEng[i]==="v")||
                (type==="playlistFull"&&linesInPlaylistFullEng[i]==="v")||
                (type==="livePost"&&linesInLivePostEng[i]==="v")||
                (type==="fullVideoLive"&&linesInFullVideoLiveEng[i]==="v")||
                (type==="fiveLive"&&linesInFiveLiveEng[i]==="v")||
                (type==="event"&&linesInEventEng[i]==="v")
              ){
                    if(currLine!==""&&currLine!=="_שורה_ריקה_"){
                        console.log(currLine);
                        var testH4 = document.createElement("h4");
                        testH4.innerHTML = currLine;
                        testDiv.append(testH4);
                    }
                    if(currLine==="_שורה_ריקה_"){
                        console.log(currLine);
                      var testH4 = document.createElement("h4");
                        testH4.innerText = "<br>";
                        testH4.innerHTML = currLine;
                        testH4.style.color="white";
                        testDiv.append(testH4);
                    }

            }
            currLine="";
        }
    }
    
}
function removeAllChildNodes(parent) {
  while (parent.firstChild) {
    parent.removeChild(parent.firstChild);
  }
}
function swapData4titles(line){
    if(line.includes("topicOfStory")){
        line=line.replace("topicOfStory", selectedPerson.topicOfStory);
    }
    if(line.includes("guestName")){
        line=line.replace("guestName", selectedPerson.name);
    }
    if(line.includes("chainName")){
        line=line.replace("chainName", currChain.name);
    }
    if(line.includes("order")){
        line=line.replace("order", document.getElementById("order").value);
    }
    if(line.includes("ID")){
        line=line.replace("ID", selectedPerson.id);
    }
    if(line.includes("IdE")){
        line=line.replace("IdE", selectedPerson.ide);
    }
    if(line.includes("firstNameOfGuest")){
        line=line.replace("firstNameOfGuest", fixFirstName(selectedPerson.name));
    }
    return line;
}
function swapWithData(line){
    if(line.includes("fullVideoLink")){
        if(document.getElementById("linkToFull").value!==""){
            line=line.replace("fullVideoLink", document.getElementById("linkToFull").value);
        }
        if(document.getElementById("linkToFull").value===""){
            line=line.replace("fullVideoLink", document.getElementById("linkToFive").value);
            if(line.includes("לראיון המלא:")){
                line=line.replace("לראיון המלא:", "לסיפור555:");
            }
            if(line.includes("the interview:")){
                line=line.replace("the interview:", "Story555:");
            }
            if(document.getElementById("linkToFive").value===""){
                line="";
            }
             if(document.getElementById("shortHeb").checked ||
                document.getElementById("shortEng").checked||
                document.getElementById("fiveLiveHeb").checked||
                document.getElementById("fiveLiveEng").checked){
                    line="";
            }
        }       
    }
     if(line.includes("topicOfStory")){
        line=line.replace("topicOfStory", selectedPerson.topicOfStory);
        if(selectedPerson.topicOfStory==="")
            line="";
    }
    if(line.includes("message")){
        line=line.replace("message", selectedPerson.message);
        if(selectedPerson.message==="")
            line="";
    }
     if(line.includes("virtue")){
        line=line.replace("virtue", selectedPerson.virtue);
        if(selectedPerson.virtue==="")
            line="";
    }
     if(line.includes("aboutTheGuest")){
        line=line.replace("aboutTheGuest", selectedPerson.abouttheguest);
        if(selectedPerson.abouttheguest==="")
            line="";
    }
    if(line.includes("guestName")){
        line=line.replace("guestName", selectedPerson.name);
        if(selectedPerson.name==="")
            line="";
    }
    if(line.includes("facebookLink")){
        line=line.replace("facebookLink", selectedPerson.facebook);
        if( selectedPerson.facebook==="")
            line="";
    }
    if(line.includes("instagramLink")){
        line=line.replace("instagramLink", selectedPerson.instagram);
        if( selectedPerson.instagram==="")
            line="";
    }
    if(line.includes("websiteLink")){
        line=line.replace("websiteLink", selectedPerson.sites);
        if(selectedPerson.sites===""||selectedPerson.sites===" ")
            line="";
    }
    if(line.includes("chainName")){
        if(!line.includes("תגיות")&&!line.includes("Tags"))
            line=line.replace("chainName", currChain.name);
        if(line.includes("תגיות")||line.includes("Tags")){
            line=line.replace("chainName", fixTags(currChain.name));
        }
        if(currChain.name==="")
            line="";
    }
    if(line.includes("chainDescription")){
        line=line.replace("chainDescription", currChain.description);
        if(currChain.description==="")
            line="";
    }
    if(line.includes("chainAbout")){
        line=line.replace("chainAbout", document.getElementById("linkToExplain").value);
        if(document.getElementById("linkToExplain").value==="")
            line="";
    }
    if(line.includes("chainParticipants")){
        line=line.replace("chainParticipants", currChain.participants);
        if(currChain.participants==="")
            line="";
    }
    if(line.includes("playlistLink")){
        line=line.replace("playlistLink", document.getElementById("linkToPlaylist").value);
        if(document.getElementById("linkToPlaylist").value==="")
            line="";
    }
    if(line.includes("date")){
        if(selectedPerson.date!=="")
            line=line.replace("date", fixDate(selectedPerson.date));
        if(selectedPerson.date==="")
            line="";
    }
     if(line.includes("hour")){
        if(selectedPerson.hour!=="")
            line=line.replace("hour", fixHour(selectedPerson.hour));
        if(selectedPerson.hour==="")
            line="";
    }
    if(line.includes("interviewerName")){
        line=line.replace("interviewerName", selectedPerson.interviewerName);
        if(selectedPerson.interviewerName==="")
            line="";
    }
    if(line.includes("email")){
        line=line.replace("email", selectedPerson.email);
        if(selectedPerson.email==="")
            line="";
    }
    if(line.includes("guestPhone")){
        line=line.replace("guestPhone", selectedPerson.guestphone);
        if(selectedPerson.guestphone==="")
            line="";
    }
    if(line.includes("interviewerPhone")){
        line=line.replace("interviewerPhone", selectedPerson.interphone);
        if(selectedPerson.interphone==="")
            line="";
    }
    if(line.includes("prepTalkLink")){
        line=line.replace("prepTalkLink", document.getElementById("linkToPrep").value);
        if(document.getElementById("linkToPrep").value==="")
            line="";
    }
    return line;
}
function fixTitle(type,lang) {
    var finalTitle="";
    var finalType="";
    if(lang==="heb"){
        finalType=type+"Heb";
    }
    if(lang==="eng"){
        finalType=type+"Eng";
    }
    finalTitle=swapData4titles(titles[finalType]);
    document.getElementById("title").innerHTML=finalTitle;
}
function fixFirstName(fullName){
    const splittedName = fullName.split(" ");
    var firstName = splittedName[0];
      if (
        firstName === 'ד"ר' ||
        firstName === "ד״ר" ||
        firstName === "דוקטור" ||
        firstName === "פרופסור" ||
        firstName === "פרופ'"||
           firstName === "Dr."||
          firstName === "Doctor"||
          firstName === "Professor" ||
     firstName === "הרב" ||
     firstName === "ד״ר" ||
     firstName === 'עו"ד'||
      firstName === 'עו״ד'
      ) {
        firstName = splittedName[1];
      }
    return firstName;       
}
function endsWithNumber(str) {
  str = str.trim();
  return isNaN(str.slice(-1)) ? false : true;
}
function changeTimeZone(date, timeZone) {
  if (typeof date === 'string') {
    return new Date(new Date(date).toLocaleString('en-US', { timeZone }));
  }
  return new Date(date.toLocaleString('en-US', { timeZone }));
}