Friday, November 4, 2011

How to get back ubuntu panel with default icons

Once the Terminal window opens, enter the following command at the prompt:

gconftool-2 – -shutdown

(Note: There should be no spaces between the two dashes before shutdown.)

EDIT – Reader nickrud has suggested a better method instead of shutting down gconfd. Instead use the following command (thanks nickrud!)

gconftool – -recursive-unset /apps/panel

(Remember: There should be no spaces between the two dashes before shutdown.)

Then enter the next command:

rm -rf ~/.gconf/apps/panel

And enter one more command:

pkill gnome-panel

That's it!

Both top and bottom panels will appear (if missing) with their default settings. Now you can customize them to your preference and get on with using Ubuntu.

Monday, October 10, 2011

Locale Issue resolved in Postgresql

Though I developed a full fledge application in Punjabi for Complaint Management Branch of DC Office in Punjabi, but yesterday I faced a hrassing issue of POSTGRESQL. I did not know why it happened, why I was not able to resolve it yesterday?

I was testing the application yesterday on Windows , because I am making the application Cross Browser Compatible and yes OS Independent too. Thatzz why I need testing. But I faced very absurd issue, absurd so because i did it earlier and now i am not being able to understand it. Actually while Entering data in Punjabi I realized data being entering in glyph form.

At first I realized that issue might be non- rendering of Unicode by windows, so i make some changes in php files to make it work. But then i realized that something is wron with the database. I found that LC_Collate and LC_Ctype (i.e localization issue was there). So, I keep on searching and searching to change the locale (which was the main blunder I was making.)

I even changed the OS system locale and tried for that but not complete results obtained.

And Today In the evening when I was sleeping consciously, I realised that I had heard about a 'C' being used in lc_collate and lc_ctype . I kept on thinking What was that?

Then I understood that this is what i was looking for, setting lc_collation and lc_ctype to 'C' and defining encoding to UTF-8 will make you to enter any sort of language supporting unicodes.

In linux one is not going to face such issues because in that what you need to do is that.

Go, to System->Administration->Language Support.

You will see two tab . 1) Language and 2) Text

Select English(Indian) after that installing postgresql will set your database to default locale of 'en_IN' which will allow to enter hindi, punjabi, english and any language that India supports. ;-)

But it sets this to default , if you will fall in love with latin or greek some day and wants to enjoy those beautiful structure of glyph of these language in db you wont be able to do it with your predefined lc_collation.

In that case and in case of windows you have to use lc_collation and lc_ctype to be 'C'.

Not a big thing to do that just define this thing while creating database.

See some screenshot below:-

[caption id="attachment_72" align="aligncenter" width="1024" caption="LC_COLLATION and LC_CTYPE"]LC_COLLATION and LC_CTYPE[/caption]

Another image show data stored in punjabi.

[caption id="attachment_73" align="aligncenter" width="1024" caption="Punjabi Data Entered in POSTGRESQL"]Punjabi Data Entered in POSTGRESQL[/caption]

Thursday, September 29, 2011

Bank Salary Slip Generation for Payroll Management System

Today I completed, one more section of Payroll Management System and that is Generation of Bank Salary Slip. As I am making this Web Based payroll software for a contract based firm working at Trident Group, dhaula, they need an individual slip which they ll give to Bank for payment of their employees. So, I did the same.

Here is the code for the bankslip.php to generate odt
<?php
session_start();
if($_SESSION['user']!='admin') {
    header('location:../checklogin/error.php');
}
require_once('../library/odf.php');
include '../dbfiles/config.php';
class bankslip {
    private $op;
    private $query;
    public function download_slip() {
        $odf = new odf("bankslip.odt");
        if($_POST['month']!='' && $_POST['year']=='') {
            echo "<script>alert('You forgot to submit year'); window.location='bankslip.php';</script>";
        }
        elseif ($_POST['month']=='' && $_POST['year']!='') {
            echo "<script>alert('You forgot to enter month'); window.location='bankslip.php';</script>";
        }
        elseif (($_POST['month']!='' && $_POST['year']!='') && $_POST['current']!='') {
            echo "<script>alert('Hello!! I didnt told you to select all options'); window.location='bankslip.php';</script>";
        }
        elseif (($_POST['month']=='' && $_POST['year']=='') && $_POST['current']=='') {
            echo "<script>alert('Hello!! I told you to select one option'); window.location='bankslip.php';</script>";
        }
        elseif ($_POST['month']!=''&& $_POST['year']!='') {
            $this->op= 'defined';
            $month= $_POST['month'];
            $year= $_POST['year'];

        }
        elseif ($_POST['current']!='') {
            $this->op= 'current';
            $month= date('n')-1;
            $year= date('Y');
        }
        switch ($month) {
            case 1:
                $monthname= 'January';
                break;
            case 2:
                $monthname= 'February';
                break;
            case 3:
                $monthname= 'March';
                break;
            case 4:
                $monthname= 'April';
                break;
            case 5:
                $monthname= 'May';
                break;
            case 6:
                $monthname= 'June';
                break;
            case 7:
                $monthname= 'July';
                break;
            case 8:
                $monthname= 'August';
                break;
            case 9:
                $monthname= 'September';
                break;
            case 10:
                $monthname= 'October';
                break;
            case 11:
                $monthname= 'November';
                break;
            case 12:
                $monthname= 'December';
                break;
        }
        $odf->setVars('month', $monthname);
        $odf->setVars('year', $year);
        $this->query= mysql_query("Select workers.id as id, worker_fname, worker_lname, gross, hra, rate, workdays, pf, esi, advance, accno from workers, worker_fixeds, worker_varys, worker_acc where workers.id=worker_fixeds.worker_id and workers.id=worker_varys.id and workers.id=worker_acc.id and month='$month' and year='$year'");
        $bank = $odf->setSegment('emp');
        $s=1;
        while($result= mysql_fetch_array($this->query)) {
            if(!$result) {
                header('location:qerror.php?op='.mysql_error());
            }
            $cal= sprintf('%.2f',($result['rate'])*($result['workdays']));
            $ded= $result['pf']+$result['esi']+$result['advance'];
            if($result['workdays']<20) {
                $wages= sprintf('%.2f',(($result['rate'])*($result['workdays']))+0);
                $netpay= sprintf('%.0f', ($wages-$ded));
                $total= sprintf('%.0f', ($total+$netpay));
            }
            else {
                $wages= sprintf('%.2f',(($result['rate'])*($result['workdays']))+$result['hra']);
                $netpay= sprintf('%.0f', ($wages-$ded));
                $total= sprintf('%.0f', ($total+$netpay));
            }
            $bank->s($s);
            $bank->accno($result['accno']);
            $bank->name($result['worker_fname'].' '.$result['worker_lname']);
            $bank->amount($netpay);
            $bank->merge();
            $s=$s+1;
        }
        $odf->mergeSegment($bank);
        $odf->setVars('total', $total);
        $odf->exportAsAttachedFile('Bankslip.odt');
    }
}
$bank_slip= new bankslip();
$bank_slip->download_slip();
?>

Wednesday, September 28, 2011

JOD Converter, a Great Utility for Conversion of the Documents

There is always a requirement for a programmer to be able to present the reports and all other important documents in various available formats and this was a requirement for me too. So, to add this ability to my existing and upcoming projects too, I looked upon the existing solution suitable for me. And thus after a lot of search I found a solution, a utility that will be helpful to me to perform the conversion of these files.

It is JOD COnverter. (Not a S/W purely, it is a library basically.)

JODConverter, the Java OpenDocument Converter, converts documents between different office formats. It leverages OpenOffice.org, which provides arguably the best import/export filters for OpenDocument and Microsoft Office formats available today.

JODConverter automates all conversions supported by OpenOffice.org, including

  • Microsoft Office to OpenDocument, and viceversa

    • Word to OpenDocument Text (odt); OpenDocument Text (odt) to Word

    • Excel to OpenDocument Spreadsheet (ods); OpenDocument Spreadsheet (ods) to Excel

    • PowerPoint to OpenDocument Presentation (odp); OpenDocument Presentation (odp) to PowerPoint

  • Any format to PDF

    • OpenDocument (Text, Spreadsheet, Presentation) to PDF

    • Word to PDF; Excel to PDF; PowerPoint to PDF

    • RTF to PDF; WordPerfect to PDF; ...

  • And more


    • OpenDocument Presentation (odp) to Flash; PowerPoint to Flash

    • RTF to OpenDocument; WordPerfect to OpenDocument

    • Any format to HTML (with limitations)

    • Support for OpenOffice.org 1.0 and old StarOffice formats

    • ..

Tuesday, September 27, 2011

Branch/Dept Detail entering Section for CMS

R&D is also going hand in hand with the Project Development of S/W. Today I worked on a new section for Complaint Management system. This section was of Entering new details of New Branch/Dept into the DB, to whom complaint has been not directed so far. By doing so they ll make an entry which they will going to refer late on while creating dispatch and entering complaints.

Take a look below on the section designed:-

Though Javascript validations is still to be done...

[caption id="attachment_59" align="aligncenter" width="1024" caption="Branc/Dept detail entering section"]Branc/Dept detail entering section[/caption]

Monday, September 26, 2011

PHP explode function on array

Today while working on the project of PHP-Reportica , I felt need of  applying php explode function on some php variable. Though usage of explode function was bit easy and I already used it, but this time I need to use it in much complicated way.

I was having a field with value of  selected_table_name.select_field_name. Now I had easily separated these two using function as:-

$explode_data= explode(".",  $tab_field);

Two arrays are formed now viz.  $explode_data[0] and $explode_data[1]. But issue was that first array might have redundant entries of same table names. Now, I stuck at this point, How to do it???

I find solution after about one hour spending one this thing. I came to know about a PHP function called unique array which removes redundant entries from an array.  Here below is what I needed:-
 foreach ($_POST['selfield'] as $mystring) {
$rs=explode(",",$mystring);
$first[]= $rs[0];
}
$uniqtab= array_unique($first);
$count= count($uniqtab);
$i=0;
foreach ($uniqtab as $table){
    echo $table;
     if ($i < ($count - 1)) {
      echo ', ';
   }
   $i=$i+1;
}

Friday, September 23, 2011

Salary Slip Generation for Payroll System

Today I am Done with generation of salary slip for Workers in Payroll Management System. for the time I am done with only the phase of downloading complete slips for every employee.

Here Below is snapshot:-

[caption id="attachment_45" align="aligncenter" width="1024" caption="Salary Slip Generation"]Salary Slip Generation[/caption]

And below is the Complete Coding for Generating the Odt file
<?php
require_once('../library/odf.php');
include_once '../dbfiles/config.php';
class salaryslip {
private $query= array();
private $result= array();
private $calsal;
private $acc;
private $ded;
private $totwages;
private $netpay;
private $month;
public function slip() {
$odf = new odf("slip.odt");
$article = $odf->setSegment('articles');
$this->month= date('n')-1;
if($_GET['op']=='comp') {
$this->query[0]= mysql_query("Select workers.id as id, worker_fname, worker_lname, gross, hra, rate, workdays, pf, esi, advance, accno from workers, worker_fixeds, worker_varys, worker_acc where workers.id=worker_fixeds.worker_id and workers.id=worker_varys.id and workers.id=worker_acc.id and month='$this->month'");
if(!$this->query[0]) {
header('location:qerror.php?op=uperror');
}
while($this->result[0]=mysql_fetch_array($this->query[0])) {
$comp_name= $this->result[0]['worker_fname'].' '.$this->result[0]['worker_lname'];
$this->ded=($this->result[0]['pf']+$this->result[0]['esi']+$this->result[0]['advance']);
$article->name($comp_name);
$article->accno($this->result[0]['accno']);
$article->ecode($this->result[0]['id']);
$article->basic($this->result[0]['gross']);
$article->days($this->result[0]['workdays']);
$this->calsal= sprintf('%.2f',($this->result[0]['rate'])*($this->result[0]['workdays']));
$article->calsal($this->calsal);
if($this->result[0]['workdays']<20) {
$article->hra('0');
$this->totwages=sprintf('%.2f',($this->calsal)+0);
$article->total($this->totwages);
}
else {
$article->hra($this->result[0]['hra']);
$this->totwages=sprintf('%.2f',($this->calsal)+$this->result[0]['hra']);
$article->total($this->totwages);
}
$article->pf($this->result[0]['pf']);
$article->esi($this->result[0]['esi']);
$article->advance($this->result[0]['advance']);
$article->totalded($this->ded);
$this->netpay= sprintf('%.2f',($this->totwages)-($this->ded));
$article->netpay($this->netpay);
$article->merge();
}
}
$odf->mergeSegment($article);
$odf->exportAsAttachedFile('CompleteSlip.odt');
}
}
$sh= new salaryslip();
$sh->slip();
?>

Thursday, September 22, 2011

Total For Final Salary sheet of Project

One thing which I forgot was total of each field  i.e gross, hra, cal salary, total wages, pf, esi etc. What I did, I declared an array named total in class finalsheet of page salarysheet.php

So Code Snippet got modified as below:-
<?php class finalsheet{
private $query= array();
private $result= array();
private $total= array();
private $calsal;
private $ded;
private $totwages;
private $netpay;
private $month;
public function seedata(){
$this->total[1]=0;
$this->total[2]=0;
$this->total[3]=0;
$this->total[4]=0;
$this->total[5]=0;
$this->total[6]=0;
$this->total[7]=0;
$this->total[8]=0;
$this->total[9]=0;
$this->total[10]=0;
$this->total[11]=0;
$this->month= date('n')-1;
$this->query[0]=mysql_query("Select id from worker_varys where month='$this->month'");
$count= mysql_num_rows($this->query[0]);
if($count==0){
echo "<script>var check= confirm('No data for updation');
if(check==true){
window.location='newsheet.php';}
else{
window.location='adminhome.php';}
</script>";
}
else{
$this->query[1]= mysql_query("Select workers.id as id, worker_fname, worker_lname, gross, hra, rate, workdays, pf, esi, advance from workers, worker_fixeds, worker_varys where workers.id=worker_fixeds.worker_id and workers.id=worker_varys.id and month='$this->month'");
if(!$this->query[1]){
header('location:qerror.php?op=uperror');
}
$this->i=1;
while($this->result[2]=mysql_fetch_array($this->query[1])){
if(($this->i)%2==0){
echo "<tr>";
}
else{
echo "<tr>";
}
echo "<input type='hidden' name=id[] value=".$this->result[2]['id']." />";
echo "<td>".$this->i."</td>";
echo "<td style='width:120px;'>".$this->result[2]['worker_fname'].' '.$this->result[2]['worker_lname']."</td>";
echo "<td>".$this->result[2]['gross']."</td>";
echo "<td>".$this->result[2]['rate']."</td>";
echo "<td>".$this->result[2]['workdays']."</td>";
$this->calsal= sprintf('%.2f',($this->result[2]['rate'])*($this->result[2]['workdays']));
echo "<td>".$this->calsal."</td>";
if($this->result[2]['workdays']<20){
echo "<td>0</td>";
$this->total[5]= sprintf('%.2f', ($this->total[5]) + 0);
$this->totwages=sprintf('%.2f',($this->calsal)+0);
echo "<td>".$this->totwages."</td>";
}
else{
echo "<td>".$this->result[2]['hra']."</td>";
$this->total[5]= sprintf('%.2f', ($this->total[5]) + ($this->result[2]['hra']));
$this->totwages=sprintf('%.2f',($this->calsal)+$this->result[2]['hra']);
echo "<td>".$this->totwages."</td>";
}
echo "<td>".$this->result[2]['pf']."</td>";
echo "<td>".$this->result[2]['esi']."</td>";
echo "<td>".$this->result[2]['advance']."</td>";
$this->ded=($this->result[2]['pf']+$this->result[2]['esi']+$this->result[2]['advance']);
echo "<td>".$this->ded."</td>";
$this->netpay= sprintf('%.2f',($this->totwages)-($this->ded));
echo "<td>".$this->netpay."</td>";
$this->total[1]= $this->total[1] + $this->result[2]['gross'];
$this->total[2]= sprintf('%.2f', ($this->total[2]) + ($this->result[2]['rate']));
$this->total[3]= sprintf('%.2f', ($this->total[3]) + ($this->result[2]['workdays']));
$this->total[4]= sprintf('%.2f', ($this->total[4]) + ($this->calsal));
$this->total[6]= sprintf('%.2f', ($this->total[6]) + ($this->totwages));
$this->total[7]= sprintf('%.2f', ($this->total[7]) + ($this->result[2]['pf']));
$this->total[8]= sprintf('%.2f', ($this->total[8]) + ($this->result[2]['esi']));
$this->total[9]= sprintf('%.2f', ($this->total[9]) + ($this->result[2]['advance']));
$this->total[10]= sprintf('%.2f', ($this->total[10]) + ($this->ded));
$this->total[11]= sprintf('%.2f', ($this->total[11]) + ($this->netpay));
echo "</tr>";
$this->i=$this->i+1;
}
echo '<tr><td colspan="2" align="right" style="font-size:medium;">Total
</td>';
echo '<td>'.$this->total[1].'</td>';
echo '<td>'.$this->total[2].'</td>';
echo '<td>'.$this->total[3].'</td>';
echo '<td>'.$this->total[4].'</td>';
echo '<td>'.$this->total[5].'</td>';
echo '<td>'.$this->total[6].'</td>';
echo '<td>'.$this->total[7].'</td>';
echo '<td>'.$this->total[8].'</td>';
echo '<td>'.$this->total[9].'</td>';
echo '<td>'.$this->total[10].'</td>';
echo '<td>'.$this->total[11].'</td></tr>';
}
}
}
$sh= new finalsheet();
$sh->seedata();
?>
And Below is the screen shot of fields that get total. It is clearly visible total being performed at last row.

[caption id="attachment_41" align="aligncenter" width="1024" caption="Total of Every Field of Salary sheet"][/caption]

Wednesday, September 21, 2011

Field Listing Section of First Part of Reporting Tool

The day quite went tough as I had to struggle a lot while outputting the Field list on each selection of table via AJAX in Reporting Tool Project. But as is said, "All Well that Ends Well". Same happened with me. After doing so much struggle, I was able to resolve the issues.

Continuing to the previous Post's code,

If user selects the table, (I am showing a code snippet)

index.php
<h2><span>Please Select the </span>Credentials</h2><br/>
<form>
<label>Select The Table</label>
<?php
include_once 'config.php';
if($op=='mysql'){

}
elseif ($op=='postgresql') {
$query=pg_query("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';");
echo '<select name="table" onchange="return showfield(this.value);">';
while($result=pg_fetch_array($query)){
echo'<option value="'.$result['table_name'].'">'.$result['table_name'].'</option>';
}
}
echo '</select>';
?>
</form>

After that is shown

ajax.js
function showfield(str)
{
var xmlhttp;
if (str=="")
{
document.getElementById("result").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("result").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","showfield.php?table="+str,true);
xmlhttp.send();
}

This above ajax.js script which is issuing an ajax call for every selection of new table from the list.

and after that is

showfield.php
<?php
include_once 'config.php';
$t=$t.$_GET['table'];
$query= pg_query("SELECT column_name FROM information_schema.columns WHERE table_name ='$t';");
echo '<table border=1>';
echo '<tr><th colspan="5">Select Field</th></tr><tr>';
$i=1;
while($result=pg_fetch_array($query)){
echo '<td><input type="checkbox" name="field[]" value="'.$result['column_name'].'"/>'.$result[column_name].'</td>';
$i=$i+1;
if($i>5){
echo '</tr><tr>';
$i=1;
}
}
echo '</tr><tr><td colspan="5"><input type="submit" value="Enter fields" onclick="enterfield();" /></td>';
echo '<td colspan="5"><input type="submit" value="Clear Selected Fields" onclick="clear();" /></td></tr>';
echo '</table>';
?>

Which will List the all fields for a table. On the Selection of which and after submission will added to another table and user will again allowed to check whether they are sure to opt for all these fields. So Next Task after this will be Selection of Fields and Confirmation and Submission for Query Generation.

Tuesday, September 20, 2011

UML Diagram of Payroll System

Today I completed the Basic Functionality of Payroll Management System. Here Below is the UML Diagram for Payroll Management System. R&D of both projects Complaint Management system and Payroll Management System will go hand in hand.

[caption id="attachment_33" align="aligncenter" width="1024" caption="UML Diagram of Payroll system"][/caption]

Monday, September 19, 2011

Selection of Formatting Logic

Logic Behind Generating is query is clearly visible in my mind, but I was stuck with the thing that how I am going to display the O/P in which format and that too importanly how???  So Brainstorming begins and along with that searching too, so as to collect some information about Formatting of Reports. But I did not work. so Whole Day went in thinking about the formatting. Hope fully tomorrow I will get the solution

Friday, September 16, 2011

Table Listing in Reporting tool Project

So, Today I started first with preparing Front End page for Selecting out which Tables of  database you want to work on. While Selecting a table you will be prompted to select the Fields, from which you have to select the fields for your query.  Ok Leave it this          is the next part of phase 1.

Below is the code discussed which is front end and will show you the each and every table of selected database:-

index.php
<html lang="en">
<head>
<script class="jsbin" src="jquery.min.js"></script>
<meta charset="utf-8" />
<link href="tablecloth/tablecloth.css" rel="stylesheet" type="text/css" media="screen" />
<script type="text/javascript" src="tablecloth/tablecloth.js"></script>
<script type="text/javascript" src="myscript.js"></script>
<script type="text/javascript">
var t = new ScrollableTable(document.getElementById('myScrollTable'), 150,250);
</script>

<title></title>
<script>
function showfield()// jQuery Function
{
var name = $("input[name='table']:checked").val();
jQuery.ajax({
url:'showfield.php',
type:"POST",
data: { clientdata : name },
success:function(data){ document.getElementById("result").innerHTML= data;}
});
return false;
}
</script>
<script>
function enterfield()// jQuery Function
{
var Selected = new Array();
jQuery("input[name='field[]']:checked").each(function(){
Selected.push(jQuery(this).val());
});

jQuery.ajax({
url:'enterfield.php',
type:"POST",
data: { clientdata : Selected },
success:function(data){ document.getElementById("enterfield").innerHTML= data;}
});
return false;
}
</script>
</head>
<body>
<form>
<table style="margin-left: auto; margin-right: auto;" id="myScrollTable">
<tr>
<th>
Select Table
</th>
</tr>
<?php
include_once 'config.php';
if($op=='mysql'){

}
elseif ($op=='postgresql') {
$query=pg_query("SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';");
/*Above Query retrieve table names from selected database in config.php */ 
while($result=pg_fetch_array($query)){
echo'<tr><td>';
echo'<input type="radio" name="table" value="'.$result['table_name'].'"onclick="showfield();" />'.$result['table_name'].'</td>';
echo '</tr>';
}
}
?>
</table>
</form>
<div id="result">

</div>
<div id="enterfield">

</div>
<p><tt id="results"></tt></p>
</body>
</html>

After That is the showfield.php from which fields for table are displayed for every click on radio button of table
showfield.php
<?php
include_once 'config.php';
$t= $_POST['clientdata'];
$query= pg_query("SELECT column_name FROM information_schema.columns WHERE table_name ='$t';");
echo '<table>';
echo '<tr><th>Select Field</th></tr>';
while($result=pg_fetch_array($query)){
echo '<tr><td><input type="checkbox" name="field[]" value="'.$result['column_name'].'" onclick="enterfield();"/>'.$result[column_name].'</td></tr>';
echo'</br>';
}
echo '</table>';
?>

Thursday, September 15, 2011

Reporting Tool for PHP

Today I am over to my 3rd project that is the Reporting tool for PHP. As far as DIO Sir searched and also I searched we had not found any suitable tool for PHP to generate automatic reports on the basis of queries that are being generated. Those We found are not FOSS and which are FOSS were not living upto our expectations.

So An anlaysis started today regarding Generation of PHP Reporting Tool.

I divided it into 3 sections as per as following:-

  1. Dynamic Query Generation

  2. Display Formatted Report (preferably in Doc) on the basis of user selection of Fields formatting

  3. Final PHP code generated which is report code and can be integrated with the project


So I will work on these phases one by one. And Regarding the Feasibility of this Project, This Project is quite feasible but being feasible it is quite time consuming. Because I need to work a lot on the formatting of reports.

Wednesday, August 17, 2011

Reporting in Complaint Management System

Today I did the last remaining job of the Complaint Management System Project, and that was the issue of Reporting. Few days earlier I got stuck regarding choosing the proper reporting tool. But then mind moved on to the my oldy friend ODTPHP and ya it's true, old is gold it would never cheat. ODTPHP made me happy and did what I wanted. But a bit stress on my mind was also put upon by me as I was not able to find any suitable o/p from googling. The feature that I was looking for in ODTPHP was that I had to insert a separate segment in a cell of every row of column. In short I need to do this:-

$odf= new odf("report.php");

$article= $odf->setSegment('complaint');

while(some cond){

$article->dispatch->setVars();

}

Thursday, August 11, 2011

Installing Django on ubuntu

Hello Visitors, A Post after a long long time, currently I am getting my training at NIC Barnala for my degree course. I had done a project in php for NIC now I got bored from it and wanna shift to Some other framework or Scripting language. This time I selected Django framework based on python. Below are the steps to install it. The Project is a surprise :-

Install server software


Install Apache, Mod_Python, MySQL and MySQLdb. MySQLdb is the database bindings for MySQL. Django also supports PostgreSQL, Oracle and SQLite. If you choose to use a different database server, be sure to install the appropriate Python bindings.

sudo apt-get install apache2 libapache2-mod-python

sudo apt-get install mysql-server python-mysqldb

Install the Django source code

At this point you have a couple of options. You could “apt-get install” a Django package, install an official release or install the development version. I chose to install the development version because it contains the latest bug fixes and features. We’ll be checking out the latest version from its Subversion repository. You’ll want to be in your home directory when you do this.
cd ~/
svn co http://code.djangoproject.com/svn/django/trunk/ django_src

Python won’t recognize Django unless it is installed in the “site-packages” directory, so instead we just create a symbolic link to the source code in our home directory. Run the first command to find out the path to your “site-packages” directory. Then use it in the second command, in place of “YOUR-DIR”. Lastly, copy the django-admin.py file into /usr/local/bin so that we don’t have to qualify the command with the full path to the file.

python -c "from distutils.sysconfig import get_python_lib; print get_python_lib()"



ln -s `pwd`/django_src/django YOUR-DIR/django



sudo cp ~/django_src/django/bin/django-admin.py /usr/local/bin

Create Django’s directories

Next we need to create some directories that Django will use. Once again, create these under your home directory.
cd ~/
mkdir django_projects



mkdir django_templates



mkdir media
Then we need to create some symbolic links in your webroot. The default webroot for an Apache2 installation on Ubuntu is /var/www. We are going to create a link to the media folder in your home directory, and a link to the admin_media folder which is provided in the Django source code.

cd /var/www



sudo ln -s  ~/media media



sudo ln -s ~/django_src/django/contrib/admin/media admin_media

Create a Django project

Move into your Django projects directory that we just created. We will be starting a new project using Django’s command line utility. This will give us a basic directory structure and the necessary configuration files. In my example I named the project “myproject.” Feel free to choose any name, as long as it does not conflict with any built-in Python or Django components. In particular, this means you should avoid using names like django (which will conflict with Django itself) or site (which conflicts with a built-in Python package).
cd ~/django_projects



django-admin.py startproject myproject
Edit the myproject/settings.py file and change the following sections:
  1. Uncomment and change the ADMINS settings:-

    6
    
    7
    
    8
    
    9
    
    10

    ADMINS = (
    
    
    
        ('Your Name', 'your_email@domain.com'),
    
    
    
    )


  2. Enter your database settings. You will need your database, username and password. Most likely your database server is running on the same server, so leave DATABASE_HOST blank.

    12
    
    13
    
    14
    
    15
    
    16
    
    17
    
    18
    
    19
    
    20
    
    21
    
    22

    DATABASE_ENGINE = 'mysql'           # 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
    
    
    
    DATABASE_NAME = 'django_databae'             # Or path to database file if using sqlite3.
    
    
    
    DATABASE_USER = 'you'             # Not used with sqlite3.
    
    
    
    DATABASE_PASSWORD = 'yourpassword'         # Not used with sqlite3.
    
    
    
    DATABASE_HOST = ''             # Set to empty string for localhost. Not used with sqlite3.
    
    
    
    DATABASE_PORT = ''             # Set to empty string for default. Not used with sqlite3.


  3. Change your timezone if necesary.


    19
    
    20
    
    21
    
    22
    
    23
    
    24
    
    25
    
    26
    
    27
    
    28
    
    29


    # Local time zone for this installation. Choices can be found here:
    
    
    
    # http://www.postgresql.org/docs/8.1/static/datetime-keywords.html#DATETIME-TIMEZONE-SET-TABLE
    
    
    
    # although not all variations may be possible on all operating systems.
    
    
    
    # If running in a Windows environment this must be set to the same as your
    
    
    
    # system time zone.
    
    
    
    TIME_ZONE = 'America/Chicago'


  4. Point Django at the template directory we created.


    69
    
    70
    
    71
    
    72
    
    73
    
    74
    
    75

    TEMPLATE_DIRS = (
    
    
    
    "/home/YOUR_USERNAME/django_templates"
    
    
    
       # Put strings here, like "/home/html/django_templates" or "C:/www/django/templates".
    
    
    
    )


  5. Do the same thing for the media url and directory we created earlier.


    36
    
    37
    
    38
    
    39
    
    40
    
    41
    
    42
    
    43
    
    44
    
    45
    
    46


    # Absolute path to the directory that holds media.
    
    
    
    # Example: "/home/media/media.lawrence.com/"
    
    
    
    MEDIA_ROOT = '/home/YOUR_USERNAME/media/'# URL that handles the media served from MEDIA_ROOT. Make sure to use a
    
    
    
    # trailing slash if there is a path component (optional in other cases).
    
    
    
    # Examples: "http://media.lawrence.com", "http://example.com/media/"
    
    
    
    MEDIA_URL = 'http://yourdomain.com/media/'


  6. Set the admin media directory that we created in your webroot


    45
    
    46
    
    47
    
    48
    
    49
    
    50
    
    51


    # URL prefix for admin media -- CSS, JavaScript and images. Make sure to use a
    
    
    
    # trailing slash.
    
    
    
    # Examples: "http://foo.com/media/", "/media/".
    
    
    
    ADMIN_MEDIA_PREFIX = '/admin_media/'


  7. And finally, add the admin application to your install applications


    76
    
    77
    
    78
    
    79
    
    80
    
    81
    
    82
    
    83
    
    84
    
    85
    
    86
    
    87
    
    88


    INSTALLED_APPS = (
    
    
    
       'django.contrib.auth',
    
    
    
       'django.contrib.contenttypes',
    
    
    
       'django.contrib.sessions',
    
    
    
       'django.contrib.sites',
    
    
    
       'django.contrib.admin',
    
    
    
    )

After making all those changes to the configuration we need to synchronize the Django database. You�ll also get a prompt asking you if you�d like to create a superuser account for the authentication system. Go ahead and do that.

django-admin.py syncdb

Edit the URL configuration file and uncomment the admin line. This will allow you to access the admin section later.
nano ~/django_projects/myproject/urls.py

1

2

3


     # Uncomment this for admin:



    (r'^admin/', include('django.contrib.admin.urls')),


Configure Apache and mod_python


In Apache2 on Ubuntu, changes to the Apache configuration are done to the/etc/apache2/httpd.conf file. We are going to configure mod_python to handle requests for the root of the site and give control to Django. However, Django doesn’t serve media files itself; it usually expects you to have a different webserver serving these files. In our case though, we want Apache to handle it, so we need to turn off mod_python for some parts of the site. You will also need to do this if you have any other folders or scripts that you want excluded from Django’s control. In my example, I have phpMyAdmin, my media folders and any URL that ends with .jpg, .gif or .png be excluded.

When deploying Django sites on mod_python, you’ll need to restart Apache each time you make changes to your Python code. However, since I’m using this as a development server, I discovered a way to avoid the hassle of having to restart the server each time. At the top of my httpd.conf, I have the line MaxRequestsPerChild 1. This forces Apache to reload everything for each request. Do not use this setting on a production server!
The only other lines you need to change are in the firstblock. Change “myproject.settings”, if you are using a different name for your project. Then below that be sure to change the PythonPath to point to the django_projects folder in your home directory.
sudo nano /etc/apache2/httpd.conf


1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36


MaxRequestsPerChild 1



   SetHandler python-program



   PythonHandler django.core.handlers.modpython



   SetEnv DJANGO_SETTINGS_MODULE myproject.settings



   PythonPath "['/home/YOUR_USERNAME/django_projects'] + sys.path"



   SetHandler None



   SetHandler None



   SetHandler None



   SetHandler None

Restart Apache

sudo /etc/init.d/apache2 restart
You can now view your new Django website by visiting the root of the website you installed it at – http://yourdomain.com/ . You should see a Page not Found (404) error message generated by Django. Congratulations! Everything is working. You can also go to http://yourdomain.com/admin/ and log in with the superuser you created earlier.

Now that you’re done with the easy part, all thats left is to get started writing your Django apps. There is a tutorial on the official Django website that will walk you through creating an application.

Monday, June 20, 2011

Making Bootable Window 7 USB from Linux

Few days earlier i got my window crashed and it started showing Boot MGR Missing. I needed a bootable window dvd. But acting as an add on to my unfortunate, DVD ROM also got ill. :P
That's why the only option was to make usb bootable. But i found so many tutorials regarding making bootable usb from windows only. From linux i found almost nothing. Then i found a useful tutorial. Here is it:-

Install ms-sys, if it is not in your repositories, get it here. and follow instruction there for installing.

Follow the following instruction:-

Create an NTFS filesystem:
# mkfs.ntfs -f /dev/sdb1
Mount ISO and USB media:
# mount -o loop win7.iso /mnt/iso
# mount /dev/sdb1 /mnt/usb
Copy over all files:
# cp -r /mnt/iso/* /mnt/usb/
Write Windows 7 MBR on the USB stick:
# ms-sys -7 /dev/sdb
...and you're done.