Wednesday, August 29, 2018

Laravel Mail send multiple email and cc

        $data=['email'=>$email,'subject'=>'ISS WORLD Account Details','bodymessage'=>$msg,'admin'=>$adminId];
     $result= Mail::send(array(), $data,function($message) use ($data){
                $message->from('vengadeschinz@gmail.com','ISS-WORLD');
               $message->to($data['email']);
             
                $message->cc($data['admin']);
                $message->subject($data['subject']);
);
      

Thursday, August 23, 2018

HTML to XLS export

 $("#export_xls").click(function(e){
    // alert('asdfasd');
    // $("#reports").table2excel({
    //   // exclude CSS class
    //   exclude: ".noExl",
    //   name: "Worksheet Name",
    //   filename: "SomeFile" //do not include extension
    // });
   // alert('hello');
    //getting values of current time for generating the file name
    var tab_text = '<html xmlns:x="urn:schemas-microsoft-com:office:excel">';
  tab_text = tab_text + '<head><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>';
  tab_text = tab_text + '<x:Name>Test Sheet</x:Name>';
  tab_text = tab_text + '<x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet>';
  tab_text = tab_text + '</x:ExcelWorksheets></x:ExcelWorkbook></xml></head><body>';
  tab_text = tab_text + "<table border='1px'>";
  var exportTable = $('#reports').clone();
  exportTable.find('input').each(function (index, elem) { $(elem).remove(); });
  tab_text = tab_text + exportTable.html();
  tab_text = tab_text + '</table></body></html>';
  var fileName = 'yearplanner_' + parseInt(Math.random() * 10000000000) + '.xls';

  //Save the file
  var blob = new Blob([tab_text], { type: "application/vnd.ms-excel;charset=utf-8" })
  window.saveAs(blob, fileName);
  /////////////////////////////
   
  });