Example #1
0
 }
 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>