} if ($valid) { //Company name of selected company value $result = mysql_query("SELECT name from sys_companies WHERE company_ref_id = '{$company}'"); $companyname = mysql_fetch_assoc($result); $result = mysql_query("SELECT u.user_id " . " FROM sys_users u " . " INNER JOIN sys_user_groups ug ON u.user_id = ug.user_id " . " INNER JOIN sys_groups g ON ug.group_id = g.group_id " . " WHERE u.user_id = {$users['user_id']} " . "\t\tAND\tg.company_ref_id = '{$company}'" . " AND g.group_name = 'Super' "); $numrows = mysql_num_rows($result); $_SESSION['super'] = $numrows > 0 ? TRUE : FALSE; $_SESSION['companyname'] = $companyname['name']; $_SESSION['company_id'] = $company; $_SESSION['user_id'] = $users['user_id']; $_SESSION['user_name'] = $users['user_name']; $_SESSION['godown'] = $users['g_code']; $_SESSION['do_restrict'] = $users['do_restrict']; include_once '../includes/connecti.php'; $date1 = getFinancialStartDate(); $date2 = date("d-m-Y"); $dates = array(); $dates['cash_book'] = $date2; $dates['voucher'] = $date2; $dates['godown_transfer'] = $date2; $dates['order'] = $date2; $dates['purchase'] = $date2; $dates['purchase_return'] = $date2; $dates['sales'] = $date2; $dates['sales_return'] = $date2; $dates['delivery_chalan'] = $date2; $dates['cheque_voucher'] = $date2; $dates['rpt_godown_stock_start'] = $date1; $dates['rpt_godown_stock_end'] = $date2; $dates['rpt_godown_transfer_start'] = $date1;
<td class="tablebody"><label for="account">Account</label></td> <td class="tablebody"> <input type="text" name="account" id="account" value="" autocomplete="off" onkeyup="javascript:ajax_showOptions(this,'1',event,'<?php echo $_SESSION['company_id']; ?> ');" class="inputs" style="text-align:left;" /> <input type="hidden" name="account_hidden" id="account_hidden" value="" /> </td> </tr> <?php } ?> <tr> <td class="tablebody"><label for="date_start">Start Date</label></td> <td class="tablebody"><input type="text" name="date_start" id="date_start" value="<?php echo getFinancialStartDate(); ?> " /></td> </tr> <tr> <td class="tablebody"><label for="date_end">End Date</label></td> <td class="tablebody"><input type="text" name="date_end" id="date_end" value="<?php echo date('d-M-Y'); ?> " /></td> </tr> <tr> <td class="tablebody">Report Type</td> <td class="tablebody"> <input id="reportPdf" type="radio" name="report" value="pdf" checked /><label for="reportPdf">PDF</label> <input id="reportExcel" type="radio" name="report" value="xls" /><label for="reportExcel">Excel</label>