Your Lodge or Grand Lodge Name Here
Free and Accepted Masons, State of California, Inc.
Craft Listing
setTableAttr('border="0" cellspacing="1" width="300" '); // $grid->setDateFormat('j M y'); // $grid->setColClass('head1,head1,head1,data1,data1,data1,head1,data1,head1,data1'); // $grid->setHeaderClass('head1'); //$grid->hideColumn(3); // $grid->setAlign(1,'C'); // $grid->setAlign(2,'C'); // $grid->setAlign(3,'C'); // $grid->setAlign(4,'C'); // $grid->setAlign(5,'C'); // $grid->setAlign(6,'C'); // $grid->setDecPlaces(7,0); // $grid->setDecPlaces(9,2); // $grid->setDecPlaces(5,2); // $grid->setSpan (1,0,2); // $grid->setSpan (3,1,0,3); // $grid->setSpan (4,0,2); // $grid->setSpan(5,0,0,3); // $grid->setSpan (6,1); // $grid->setSpan (8,1); // $grid->setAlign(3,'C'); // $grid->setOnChange(4,0,1); // $grid->noHeadings(); // $grid->display(); // with printer friendly styles include("http://mylodgehelper.net/mpdf/mpdf.php"); $mpdf=new mPDF(); $mpdf->debug = true; // Buffer the following html with PHP so we can store it to a variable later ob_start(); $sql = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS Consistory, CONCAT('Bro. ', memberfirstname, ' ',memberlastname) AS membername, membermobilephone, memberemail, memberstatus, memberseatoffice, memberrank, duespaid FROM sublodges ORDER BY Consistory, memberlastname"; //$sql = "SELECT CONCAT(lodge_name, ' #', lodge_no) AS Lodge, CONCAT('Bro. ', memberfirstname, ' ',memberlastname) AS membername, membermobilephone, memberemail, memberstatus, memberseatoffice, memberrank FROM sublodges GROUP BY Lodge"; $grid2 = new baaGrid($sql); $grid2->setColClass('data1,data2'); $grid2->setHeaderClass('head1'); $grid2->setTableAttr('border="1" cellspacing="0" width="1100"'); // $grid2->setHeaderClass('TLB,TLB,TLB,border'); // $grid2->setColClass('L,L,L,LR'); $grid2->setAlign(0,'l'); $grid2->setOnChange(0,1, 0); // $grid2->setLink(3,"mailto:"); $grid2->setSubTotalClass('T,T,TLB,border'); $grid2->setTotalClass(',,TLB,border'); // $grid2->setTotal(7); $grid2->setCount(1); $grid2->setHeadings("Consistory,Member,Mobile Phone,Email,Status,Office,Rank,Dues"); // $grid2->setDateFormat('D, jS M'); $grid2->setDateFormat('j M y'); $grid2->setWidth(0,'15%'); $grid2->setWidth(1,'25%'); $grid2->setWidth(2,'15%'); $grid2->setWidth(3,'15%'); $grid2->setWidth(5,'20%'); $grid2->showColNumbers(0); $grid2->hideColumn(7); $grid2->display(); ?>
