yb Computer MCQs, Programs, Scripts & Studies

Tuesday, August 28, 2018

006 Free php Script for a Personal Accounts Manager

Requirements for using offline on a laptop / p.c.: 1. Apache2 server, with php support. 2. Suitably changing the Configuration of the 'public_html' (or any other folder, for use as localhost, by giving Read, Write, Create files. For entering transactions, a simple Text Editor such as Notepad, Gedit, Geany can be used, and the transaction file is to be saved by giving 'mychoicename.txt'. For preparing accounts, Trial Balance, Income and Expenditure, Balance Sheet, the a .php file name (Example mychoicefilename.php) in browsers such as firefox.

Where is the script?

Ans: The following is the script shown in red color in the following Text Area. Press 'Control A', select it, copy it to clip board, then paste it in a mychoicefilename.php file opened in a Text Editor. Save it as a .php file. This file is to be saved in in the 'Public_html' folder (or any other similar name) or in a new folder within the Public_html folder which is configured as 'localhost' in apache2 and php settings.

Read write, create file permissions are important.

Question: Will the Script Work in Windows / Linux / Mac. ?

As the script is browser based, it should work platform-independently. I have tried in Linux-Ubuntu-15.04 and Windows. It worked.

<html><head><META http-equiv='content-type; content='text/html' charset='utf-8'; lang='hi'; lang='te'; encoding='utf-8'; dir='ltr'; />
<style type='text/css'>
 table{ word-wrap:true; width:70%;}
 table td{border:.2em solid magenta; margin:  0px 0px 0px 0px; padding: 0px 0px 0px 0px; wordwrap:true;}
 table th{border:.2em solid magenta; margin:  0px 0px 0px 0px; padding: 0px 0px 0px 0px; wordwrap:true;}
 </style>
</head>

<h3>Simple php script by ybrao-a-donkey for personal accounts and small businesses </h3>

</div>

<?php  ////////////////////////////////////////////php starts////////////////////////

echo "</p><form type='text' method='GET'>";
echo "Enter the txt file name, you want to prepare your accounts";
echo "<input  type = 'text' name = 'tafilename'  value=$_GET[tafilename]      />";
echo "<br />Enter y if you want a doc file of all the a/cs.  Else enter anything.";
echo "<Input type = 'text' name = 'taoutput' value = 'n'    />";
echo "<Input type = 'submit' name = 'submitb1' method='GET' value = 'prepare' />";

//////////////////transactions file////////////

$dou1=file_get_contents($_GET[tafilename]);

//combining all the flours
$douall = $dou1;

$bre = explode("\n\n",$douall);

//////////////////for preparing all accounts from all accounts list

$sallaccolist= $bre[0];
$aallaccolist = explode("|",$bre[0]);

$no=0;
$granddebitsumma = 0;
$grandcreditsumma = 0;

$today= strftime(date("d.m.y"));

////////////////searching all accounts accounts in Transactions file
for($t=1; $t<=count($aallaccolist)-1;$t++){
 $resuallaccostableheads=  "<table border='1'   ><tr style='background:#fabfba; '><td style='border:1px double magenta;'>"
 
 
  ."<tr><th colspan='7'>STATEMENT OF ACCOUNT FOR  "  .$aallaccolist[$t]  ." as on "  .$today  ."</th></tr>"
 ."<tr><th style='border:.1em solid black; wordwrap:true; '>"  ."Date & A/c-name"  ."</th>"
 //."<th style='border:.1em solid black; '>"  ."Date"  ."</th>"
 ."<th style='border:.1em solid black; '>"  ."dr"    ."</th>"
 ."<th style='border:.1em solid black; '>"  ."cr"    ."</th>"
 ."<th style='border:.1em solid black; '>"  ."dr bal"    ."</th>"
 ."<th style='border:.1em solid black; '>"  ."cr bal"    ."</th>"
 ."<th style='border:.1em solid black;wordwrap:true;'>"  ."Contra"  ."</th>"
 ."<th style='border:.1em solid black;word-wrap:true; '>"  ."Rem."    ."</th>"
 ."<tr>";
 
 $tvallacconame=$aallaccolist[$t];
 $resuincoexp=" ";
 $debitsumma=0;
 $creditsumma=0;
 $tbdsumma =0;
 $tbcsumma=0;
 $formadebitsumma=0;
 $formacreditsumma=0;
 $accountdebitsumma=0;
 $accountcreditsumma=0;
 $debitacdebitsumma=0;
 $creditaccreditsumma=0;
 
 $bal=0;
 $dbal=0;
 $cbal=0;
 $formadbal=0;
 $formacbal=0;
 $dr=0;
 $cr=0;

for ($u=3; $u<=(count($bre)-1);$u++){
 $pos = stristr($bre[$u], $aallaccolist[$t]);

//echo $pos;
//if ($pos <>null){
if ($pos <>null){
 
 $pizza[$no]=explode("|",$bre[$u]);
 //echo $pizza[$no];
 
 $tempdate = $pizza[$no][0];
// $pattern = '/(\d{2}) ([\d{2}) ([\d{2})/i';
 
//$replacement = "$3.$2$1";
//$tempdate2 = preg_replace($pattern, $replacement, $tempdate);
//echo $tempdate2;
 $tempnarr = $pizza[$no][4];
 $tempdr=$pizza[$no][1];
 $tempcr=abs($pizza[$no][1]);
 $tempdrac=$pizza[$no][2];
 $tempcrac=$pizza[$no][3];
 $posdrac=stristr($pizza[$no][2], $aallaccolist[$t]);
 $poscrac=stristr($pizza[$no][3], $aallaccolist[$t]);
 
//if ($pizza[$no][1] < 0){
   
   //echo $pizza[$no][1];
   //echo $tempcr;
    if ($posdrac <> null)
 
 {
  $debitacdebitsumma = $debitacdebitsumma + floatval($pizza[$no][1]);
 $dr= floatval($pizza[$no][1]);
 $cr=0;
  }
 
 
 
 else  {
  
  if ($poscrac <> null){
   $creditaccreditsumma = $creditaccreditsumma + abs(floatval($pizza[$no][1]));
  $cr= abs(floatval($pizza[$no][1]));
  $dr=0;
     }  //endif for poscrac
 
 } //end else posdrac

$bal=floatval($debitacdebitsumma + $creditaccreditsumma);
$no++;
if ($bal < 0){$formadbal = "<b style='color:red;'>"   .number_format($bal,2)  ."</b>"       ;
 $dbal = $bal;
 $tbdbal=$bal;
 $cbal=0;
 $formacbal=0;
 }

else { if ($bal >= 0)$formacbal = "<b style='color:blue;'>"   .number_format($bal,2)   ."</b>"      ;
 $cbal = $bal;
 $tbcbal=$bal;
 $dbal=0;
 $formadbal=0;
 }

$resuallaccos=  $resuallaccos  
    
     ."<tr><td style='border:.1em solid green; padding:0 0 0 0;'>"  .$tempdate  ."<br />"  .$aallaccolist[$t]     ."</td>"
   // ."<td style='border:.1em solid green;padding:0 0 0 0;'>"  .$tempdate   ."</td>"
 ."<td style='text-align:right;border-right:  .1em solid grey;padding:0 0 0 0;'>"  .number_format($dr,2)     ."</td>"
 ."<td style='text-align:right;border-right:  .1em solid grey;padding:0 0 0 0;'>"  .number_format($cr,2)     ."</td>"
 
 ."<td style='text-align:right;border-right:  .1em solid grey;padding:0 0 0 0;'>"  .$formadbal   ."</td>"
 ."<td style='text-align:right;border-right:  .1em solid grey;padding:0 0 0 0;'>"  .$formacbal   ."</td>"
 ."<td style='border:.1em solid green;padding:0,0,0,0;'>"  .$tempdrac  ."<br />"    ."<-->"   .$tempcrac                 ."</td>"
 ."<td style='border:.1em solid green;wordwrap:true;padding:0 0 0 0;'>"  .$tempnarr   ."</td>"
 
 ."</tr>";

} //endif
//$no=0;

$netbal=floatval($dbal + $cbal);

$accountdebitsumma = floatval($accountdebitsumma + $debitacdebitsumma);
$accountcreditsumma = floatval($accountcreditsumma + $creditaccreditsumma);

$tbdsumma= floatval($debitacdebitsumma);
$tbcsumma= floatval($creditaccreditsumma);

$tbbal= floatval($debitacdebitsumma + $creditaccreditsumma);

if ($tbbal < 0) {
 $tbdbal = $tbbal; 
 }
 
 else 
 {$tbdbal=0;
 }
 
if ($tbbal >= 0) {$tbcbal = $tbbal;
 }
 else
 { $tbcbal=0;
 }

$grandbal = floatval($debitsumma + $creditsumma);

} //end tloop

$granddbal =  floatval($granddbal + $dbal);
$grandcbal =  floatval($grandcbal + $cbal);

$grandnetbal= floatval($grandnetbal + $netbal);
$granddebitsumma =  floatval($granddebitsumma   + $debitacdebitsumma) ;
$grandcreditsumma = floatval($grandcreditsumma   + $creditaccreditsumma) ;
$grandsummabal= floatval($granddebitsumma + $grandcreditsumma);

//calculation of summations for various accounts///////////////////////////////////
 
$resuallaccos2= $resuallaccos2     .$resuallaccos;

$resuallaccos2 = $resuallaccos2
    ."<tr style='background:#00ff00;'><td style='border:.25em solid green;'>"   ."Summations"  ."<br />"   .$tempdate    ."</td>"
   // ."<td style='border:.25em solid green;'>"  .$tempdate  ."</td>"
 ."<td style='border:.25em solid green;'>"  .number_format($debitacdebitsumma,2)  ."</td>"
 ."<td style='border:.25em solid green;'>"  .number_format($creditaccreditsumma,2)  ."</td>"
 
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($dbal,2)   ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($cbal,2)   ."</td>"
 ."</tr>";

$resuallaccos2 =  "<br /><br />"   .$resuallaccostableheads    .$resuallaccos2   ."</table>";

$resuallaccos3=$resuallaccos3.  $resuallaccos2  ;
//echo $resuallaccos2;  //see bottom
 //echo $resuallaccos3;
 $resuallaccos2= " ";
 $resuallaccos=" ";

//////////////////////////////////////////////////////////////////////////////////////////////

//for preparing trial balances
$trbaltab= $trbaltab . "<tr>"
    . "<td style='border:.25em solid green;'>"  .$aallaccolist[$t]     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbdsumma,2)  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbcsumma,2)  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbdbal,2)       ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbcbal,2)        ."</td>"
 
 
 ."</tr>";
 
$tbgdsumma = floatval($tbgdsumma + $tbdsumma);
$tbgcsumma = floatval($tbgcsumma + $tbcsumma);
$tbgdbal        = floatval($tbgdbal + $tbdbal);
$tbgcbal        = floatval($tbgcbal + $tbcbal);
 
} //for $tloop.   FROM HERE STARTS GRAND TOTALS

//for preparing trial balance sigma summations
$trbaltab= $trbaltab . "<tr style='background:magenta;'>"
    . "<td style='border:.25em solid green;'>"  ."Grand Summations"     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbgdsumma,2)  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbgcsumma,2)  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbgdbal,2)       ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($tbgcbal,2)        ."</td>"
 
 
 ."</tr>";

////////////////////////trial balance//////////

$trbaltabhead= "<br /><br /><br /><table border='1'><tr><th style='border:.2em solid black;'>"  ."Trial Balance of All Accounts"         ."</th></tr>"
  ."<tr><th style='border:.2em solid black;'>"  ."A/c name"   ."</th>"
  ."<th style='border:.2em solid black;'>"    ."a/c's debit summa"   ."</th>"
  ."<th style='border:.2em solid black;'>"    ."a/c's credit summa"  ."</th>"
  ."<th style='border:.2em solid black;'>"    ."a/c's debit balances"  ."</th>"
  ."<th style='border:.2em solid black;'>"    ."a/c's credit balances"  ."</th>"
  
  ."</tr>";

$trbaltab = $trbaltabhead    .$trbaltab   ."</table>";

//echo $trbaltab;  //trial balance

/////////////////////forincome-expenditure a/c/////////////////////////////////

//////////////////for preparing income-expenditure account

$strincoaccolist=$bre[1];
$arraincoaccolist = explode( "|", $strincoaccolist );

$ino=0;
$incogranddebitsumma = 0;
$incograndcreditsumma = 0;

$resuincoexp3="<br /><br /><table border='1'><tr style='background:#8844ff;'>"
    ."<th style='border:.2em solid black;'>"  ."Income and Expenditure Account"  . "</th></tr>"
 ."<tr style='background:#ffff99;'><th style='border:.2em solid black;'>"  ."A/c name"  ."</th>"
 ."<th style='border:.2em solid black;'>"  ."drsumma"    ."</th>"
 ."<th style='border:.2em solid black;'>"  ."crsumma"    ."</th>"
 ."<th style='border:.2em solid black;'>"  ."A/cs with debit balances"    ."</th>"
 ."<th style='border:.2em solid black;'>"  ."A/cs with credit balances"    ."</th>"
 ."<tr>";

////////////////searching Expenses and Income accounts in Transactions file
for($it=1; $it<=count($arraincoaccolist)-1;$it++){
 //starting figures for each exp and inco a/c.
 $resuincoexp=" ";
 $incodracdebitsumma=0;
 $incocraccreditsumma=0;
 $formadebitsumma=0;
 $formacreditsumma=0;
 $accountdebitsumma=0;
 $accountcreditsumma=0;
 
 $incobal=0;
 $incodbal=0;
 $incocbal=0;
 $formadbal=0;
 $formacbal=0;
 $incoaccodbal=0;
 $incoaccocbal=0;
 
 $sigmacbal=0;
 $sigmadbal=0;

for ($incou=3; $incou<=(count($bre)-1);$incou++){
 
 $pos = stristr($bre[$incou], $arraincoaccolist[$it]);

if ($pos >null){
 
 
 
 $incopizza[$ino]=explode("|",$bre[$incou]);
 
 $posincodrac=stristr($incopizza[$ino][2], $arraincoaccolist[$it]);
 $posincocrac=stristr($incopizza[$ino][3], $arraincoaccolist[$it]);
 
//if ($incopizza[$ino][1] < 0)
if  ($posincodrac <> null)

{$incodracdebitsumma = $incodracdebitsumma + floatval($incopizza[$ino][1]);}

else {

if  ($posincocrac <> null)

{$incocraccreditsumma = $incocraccreditsumma + abs(floatval($incopizza[$ino][1]));}

$incobal=floatval($incodracdebitsumma + $incocraccreditsumma);
$ino++;
} //endelse

if ($incobal < 0){$formadbal = "<b style='color:red;'>"   .$incobal  ."</b>"       ;
 $incodbal = $incobal;
 //$incoaccodbal=  floatval($incoaccodbal + $incodbal  );
 }

if ($incobal >= 0)  {$formaincocbal = "<b style='color:blue;'>"   .$incobal   ."</b>"      ;
 $incocbal = $incobal;
 //echo $incocbal   ."<br />";
 //$incoaccocbal=  floatval($incoaccocbal + $incocbal   );
 }

} //endif

$sigmadbal= floatval($incodbal);
$sigmacbal=abs(floatval($incocbal));

$inconetbal=floatval($incodbal + $incocbal);

$incograndbal = floatval($incodracdebitsumma + $incocraccreditsumma);

} //end tloop
$greatsigmadbal =  floatval($greatsigmadbal + $sigmadbal)   ; 
$greatsigmacbal =  floatval($greatsigmacbal + $sigmacbal)    ;

$incograndnetbal= floatval($incograndnetbal + $inconetbal);

$incogranddebitsumma =  floatval($incogranddebitsumma   + $incodracdebitsumma) ;
$incograndcreditsumma = floatval($incograndcreditsumma   + $incocraccreditsumma) ;

$incograndsummabal= floatval($incogranddebitsumma + $incograndcreditsumma);

if ($incograndbal <0) {$inconetcbal=0;}
if ($incograndbal >0) {$inconetdbal=0;}

if ($incograndbal < 0){$incofnetdbal = "<b style='color:red;'>"   .number_format($incograndbal,2)  ."</b>"  ;
 $incofnetcbal=0;
 
 }

if ($incograndbal > 0){$incofnetcbal = "<b style='color:blue;'>"   .number_format($incograndbal,2)  ."</b>"  ;
 $incofnetdbal=0;
}

$resuincoexp=  $resuincoexp
    . "<tr><td style='border:.25em solid green;'>"  .$arraincoaccolist[$it]     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($incodracdebitsumma,2)  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($incocraccreditsumma,2)  ."</td>"
 
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .$incofnetdbal                  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .$incofnetcbal                    ."</td>"
 
 ."</tr>";
 
$resuincoexp2= $resuincoexp2      .$resuincoexp;

} //for $itloop.  This is end of searching for exp & income accounts.

$incograndnetbal = floatval($incogranddebitsumma + $incograndcreditsumma);

if ($incograndnetbal <0) {$incofgrandnetdbal= "<b style='color:red;'>"   .number_format($incograndnetbal,2)  ."</b>";
 $incograndnetdbal=$incograndnetbal;
 $incofgrandnetcbal=0;
}

if ($incograndnetbal >0) {$incofgrandnetcbal= "<b style='color:blue;'>"   .number_format($incograndnetbal,2)  ."</b>";
 $incograndnetcbal=$incograndnetbal;
 $incofgrandnetdbal=0;
}
$incograndnetcbal = -($incograndnetcbal);

$resuincoexp2 = $resuincoexp2
    ."<tr><td style='border:.25em solid green;'>"   ."surplus/deficit"            ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  ." "    ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  ." "    ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .$incofgrandnetcbal  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .$incofgrandnetdbal  ."</td>"
 ."</tr>";

$incogreatgranddsumma = floatval($incogranddebitsumma + $incograndnetdbal);
$incogreatgrandcsumma = floatval($incograndcreditsumma + $incograndnetcbal);

$resuincoexp2 = $resuincoexp2
    ."<tr style='color:red;background:#dddddd;'><td style='border:.25em solid green;'>"   ."Grandtotals"     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($incogranddebitsumma,2)  ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($incograndcreditsumma,2)  ."</td>"

."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format(($incogreatgranddsumma)+ ($incograndnetcbal),2)    ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format(($greatsigmacbal)  + (abs($incograndnetdbal)),2)   ."</td>"
 
 ."</tr>";

//echo $greatsigmadbal;
//echo $incograndnetcbal;

$resuincoexp3=$resuincoexp3.  $resuincoexp2  ;
 $resuincoexp2= " ";

$resuincoexp3 = $resuincoexp3 . "</table";
// echo $resuincoexp3; //see bottom
$resuincoexp4=$resuincoexp4  .$resuincoexp3;

//////////////////for preparing Balance sheet, assets & liab.

$strbsaccolist=$bre[2];
$arrabsaccolist=explode("|", $strbsaccolist);

$ino=0;
$granddebitsumma = 0;
$grandcreditsumma = 0;

$resubsexp3=  "<table border='1' ><tr>"
    ."<th colspan='2' >"     ."Balance Sheet as per Trial Balance, though P&L Entries have not been passed"       ."</th></tr>"
 ."<tr><th style= 'width:5em;'>"  ."Liabilities"    ."</th>"
 ."<th style= 'width:5em;'>"  ."A/c name"  ."</th>"
 ."<th style='border:.2em solid black;width:5em;'>"  ."Assets"    ."</th>"

."</tr>";

////////////////searching assets and liabilities account in the Transaction file.  Note: Even if there are no transactions, assets and liabilities accounts may start with some opening balances.  
for($bst=1; $bst<=count($arrabsaccolist)-1;$bst++){
 //starting figures for each asset and liability account.
 $resubsexp=" ";
 $debitsumma=0;
 $creditsumma=0;
 $formadebitsumma=0;
 $formacreditsumma=0;
 $accountdebitsumma=0;
 $accountcreditsumma=0;
 $bsdracdebitsumma=0;
 $bscraccreditsumma=0;
 
 $bal=0;
 $dbal=0;
 $cbal=0;
 $bsbal=0;
 $bsnetbal=0;
 $bsfnetbal=0;
 $bsfnetdbal=0;
 $bsfnetcbal=0;
 $formadbal=0;
 $formacbal=0;

for ($bs=0; $bs<=(count($bre)-1);$bs++){
 
 
 $posbs = stristr($bre[$bs], $arrabsaccolist[$bst]);

if ($posbs <>null){
 
 $bspizza[$bsno]=explode("|",$bre[$bs]);
 
 $posbsdrac=stristr($bspizza[$bsno][2], $arrabsaccolist[$bst]);
 $posbscrac=stristr($bspizza[$bsno][3], $arrabsaccolist[$bst]);

if ($posbsdrac <> null )

{$bsdracdebitsumma = $bsdracdebitsumma + floatval($bspizza[$bsno][1]);}

if($posbscrac <> null)
{$bscraccreditsumma = $bscraccreditsumma + abs(floatval($bspizza[$bsno][1]));

} //end if

$bsbal=floatval($bsdracdebitsumma + $bscraccreditsumma);
//echo $bsbal   ."<br />";
$bsno++;

if ($bsbal < 0){
 
 $bsdbal = $bsbal;
 $bscbal=0;
 $formabsdbal = "<b style='color:red;'>"   .number_format($bsdbal,2)  ."</b>"       ;
 }

else { if ($bsbal >= 0)
 $bsdbal=0;
$bscbal = $bsbal;
$formabscbal = "<b style='color:blue;'>"   .number_format($bscbal,2)   ."</b>"      ;

}

} //endif

$bsnetbal=floatval($bsdbal + $bscbal);
//echo $bsnetbal ."<br />";
$bsnetbal=number_format($bsnetbal,2);

if($bsnetbal <0) {$bsfnetdbal = "<b style='color:red;'>"   .$bsnetbal   ."</b>";
 $bsfnetcbal=0;
 $bsgnetdbal= floatval($bsgnetdbal + $bsnetbal);
 
 }
 
 if($bsnetbal >=0) {$bsfnetcbal = "<b style='color:blue;'>"   .$bsnetbal   ."</b>";
  $bsfnetdbal=0;
  $bsgnetcbal= floatval($bsgnetcbal + $bsnetbal);
  }

} //end bstloop  //this loop completes searching for assets & liab. a/cs.

$bslbaltot= floatval($bslbaltot + $bscbal);
$bsabaltot= floatval($bsabaltot + $bsdbal);

$bsgranddbal =  floatval($bsgranddbal + $bsdbal );
$bsgrandcbal =  floatval($bsgrandcbal + $bscbal );

$resubsexp=  $resubsexp
 
 ."<tr><td style='text-align:right;border-right:  .25em solid grey;'>"  .$bsfnetcbal   ."</td>"
    . "<td style='border:.25em solid green;'>"  .$arrabsaccolist[$bst]     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .$bsfnetdbal   ."</td>"
 
 ."</tr>";
 
$resubsexp2= $resubsexp2      .$resubsexp;

} //for $bstloop.  This is end of searching for exp & income accounts.

$bsnetresult = floatval($bsgranddbal + $bsgrandcbal);
echo $bsnetresult;

if($bsnetresult > 0) {$bsdeficit = abs($bsnetresult);}
if($bsnetresult < 0) {$bssurplus = abs($bsnetresult);}
 
//deficit will should have a debit balance.  It appears on debit side.
$bsdeficit = -($bsdeficit);
$bsnfdeficit=number_format($bsdeficit,2);
$bsfdeficit= "<b style='color:red;'>"  . $bsnfdeficit  ."</b>";

$resubsexp2 = $resubsexp2 ."<tr>"
    ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($bssurplus ,2)  ."</td>"
    ."<td style='border:.25em solid green;'>"   ." Result Surplus/deficit.  Surplus will appear on liability side.  Deficit will appear on asset side. "     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .$bsfdeficit   ."</td>"
 
 ."</tr>";

$bslbaltot =floatval ($bslbaltot + $bssurplus);
$bsabaltot =floatval ($bsabaltot+ $bsdeficit);

$resubsexp2 = $resubsexp2  ."<tr style='background:#ffff44;'>"

."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($bslbaltot,2 ) ."</td>"
    ."<td style='border:.25em solid green;'>"   ."Summation Totals"     ."</td>"
 ."<td style='text-align:right;border-right:  .25em solid grey;'>"  .number_format($bsabaltot,2)  ."</td>"
 
 ."</tr>";

$resubsexp3=$resubsexp3.  $resubsexp2  ;
 $resubsexp2= " ";

$resubsexp3 = "<br /><br /><br />\n\n\n"  . $resubsexp3 . "</table>";
// echo $resubsexp3; see bottom
 
/////////////////////////////////////Showing Results on browser

echo $trbaltab;             //trial balance
echo "In the above TB, Make sure that first two columns tally; last two columns tally.  If there is difference, go to transactions .txt file, checkup latest entries / latest alterations made by you since the last trial balance.";

echo $resuincoexp3;   //income and expenditure a/c.
echo "<br /><br />";
echo $resubsexp3;      //balance sheet
echo "Result in the Income and Expenditure a/c. and the Result in Balance Sheet tally.  Thereafter, you can pass more Profit and Loss entries, and recheck the IE a/c/P&L a/c., and the Balance Sheet.";

echo $resuallaccos3;  //all accounts individually

//////////////////////////////////////////////////////////////code for searching selected item

echo "</p><form type='text' method='GET'>";
echo "<Input type = 'textarea' name = 'ndl2' value = $_GET[ndl2]  >";
echo "<Input type = 'submit' name = 'submitb2' method='GET' value = ' search ' />";

if (!isset($_GET[ndl2])) { $_GET[ndl2]='puffed';  }

//-----------------------------
echo "showing results for "   .$_GET[ndl2]   ."<br />";
echo "\n<br />";

$no=0; $pizza=array();
for ($s=0; $s<=(count($bre)-1);$s++){
 $pos = stristr($bre[$s], $_GET[ndl2]);

//if (strlen($pos) >= 0){

if ($pos <>null){

//if($pos >0){
 
 $pizza[$no]=explode("|",$bre[$s]);
 
$no++;

} //endif

} //end sloop

/////////////////////////////////////table design for the search result
$resut="<table border='1'>  <tr><th>date</th><th>dr amt</th><th>cr amt</th><th>Progressive Total</th><th>dr. account</th><th>cr. account</th><th>Remarks</th></tr>";
$debitsumma=0;
$creditsumma=0;

for ($a=0; $a <= count($pizza)-1; $a++){
 
if ($pizza[$a][1] < 0)  {  $formadr = "<b style='color:red;'>"   .floatval($pizza[$a][1])  ."</b>"       ;
 $formacr=0;  }

else { if ($pizza[$a][1] >= 0)$formacr = "<b style='color:black;'>"   .floatval($pizza[$a][1])  ."</b>"      ;
 $formadr=0;   }

//refreshing summations
if ($pizza[$a][1] < 0){$debitsumma = $debitsumma + floatval($pizza[$a][1]);}
if ($pizza[$a][1] >= 0){$creditsumma = $creditsumma + floatval($pizza[$a][1]);}

$formadebitsumma = "<b style='color:red;'>"  .$debitsumma    ."</b>";
$formacreditsumma= "<b style='color:red;'>"  .$creditsumma   ."</b>";
 
$bal=floatval($debitsumma + $creditsumma);

if ($bal < 0){$formabal = "<b style='color:red;'>"   .$bal  ."</b>"       ;}

else { if ($bal >= 0)$formabal = "<b style='color:blue;'>"   .$bal   ."</b>"      ;}

$resu = $resu   ."<tr><td style='text-align:left;border:#ff99aa;'>"   .$pizza[$a][0]  ."</td>"
 
  ."<td style='text-align:right; '>"    . $formadr   ."</td>" 
  
   ."<td style='text-align:right;'>"    . $formacr   ."</td>" 
   
  ."<td style='text-align:right; '>"    . $formabal   ."</td>" 
  
  ."<td  style='border:.2em solid blue;'>"   .$pizza[$a][2]  ."</td>" 
  
  ."<td  style='border:.2em solid yellow;'>"   .$pizza[$a][3]  ."</td>" 
 
 ."<td  style='border:.2em solid  magenta;'>"   .$pizza[$a][4]  ."</td></tr>" ;
 
 }
 
 //Grand summations for the search
$resu = $resu  
// ."<tr><td>"   ." "  . "</td>"
."<td>"   ."Balance with debit and credit summations"   ."</td>"

."<td style='text-align:right; width:5%;'>"    . $formadebitsumma   ."</td>" 
  
   ."<td style='text-align:right; width:5%;'>"    . $formacreditsumma   ."</td>"

."<td style='text-align:right;'>"    .$formabal  ."</td>"
 ."<td>"  ." "  ."</td></tr>";

$resut = $resut . $resu . "</table>" ;
echo $resut;

//////////////////////////////////////////////////////////////code for deepsearch

if (!isset($_GET[ndl2])) { $_GET[ndl2]='puffed';  }

//-----------------------------
echo "<br />showing results for "   .$_GET[ndl2]   ."<br />";
echo "\n<br />";

$no=0; $no2=0; $pizza=array(); $pak=array();
for ($s=0; $s<=(count($bre)-1);$s++){
 $pizza[$no]=explode("|",$bre[$s]);
 $tvpizzano = $pizza[$no];
 $burger=$pizza[$no][4];
 
 $posdees = stristr($burger, $_GET[ndl2]);

//print_r($pizza[$no]);

//if (strlen($pos) >= 0){

if ($posdees <>null){
//$pak[$pakno]=  preg_split('/(?=[a-z]+)(?<=[0-9])/i',$burger);
$pak[$pakno]=  explode(",",$burger);
$tv=$pak[$pakno];
//print_r($tv);

for($v=0; $v<=count($tv)-1; $v++){
$poslad = stristr($tv[$v], $_GET[ndl2]);

if ($poslad <>null){
$lad= $tv[$v];
$ladsplit= preg_split('/(?<=[0-9])(?=[a-z]+)/i',$lad);

//} if for poslad

//print_r($pizza[$no]);

$no++;
$ladsplitdr= floatval($ladsplit[0]);
//echo $ladsplitdr;

$ladsplitdr= -($ladsplitdr);

if ($ladsplit[0] > 0)  {  
 $formadrdees = "<b style='color:red;'>"   .$ladsplitdr  ."</b>"       ;
 $formacrdees=0;  
}
else { if ($ladsplit[0] <= 0)$formacrdees = "<b style='color:black;'>"   .floatval($ladsplit[0])  ."</b>"      ;
 $formadrdees=0;   }

//refreshing summations
if ($ladsplit[0] < 0){$debitsummadees = $debitsummadees + floatval($ladsplit[0]);}
if ($ladsplit[0] >= 0){$creditsummadees = $creditsummadees + floatval($ladsplit[0]);}

$formadebitsummadees = "<b style='color:red;'>"  .$debitsummadees    ."</b>";
$formacrdeeseditsummadees= "<b style='color:red;'>"  .$creditsummadees   ."</b>";
 
$bal=floatval($debitsummadees + $creditsummadees);

if ($bal > 0){$formabaldees = "<b style='color:red;'>"   .$bal  ."</b>"       ;}

else { if ($bal <= 0)$formabaldees = "<b style='color:blue;'>"   .$bal   ."</b>"      ;}

$resds = $resds   ."<tr><td style='text-align:left;width:3%'>"   .$tvpizzano[0]  ."</td>"
 
  ."<td style='text-align:right; width:4%;'>"    . $formadrdees   ."</td>" 
  
   ."<td style='text-align:right; width:3%;'>"    . $formacrdees   ."</td>" 
   
  ."<td style='text-align:right; width:6%;'>"    . $formabaldees   ."</td>" 
  
   ."<td  style='width:6%;'>"   .$tvpizzano[2]  ."</td>" 
  
  ."<td  style='width:6%;'>"   .$tvpizzano[3]  ."</td>" 
 
 ."<td  style='width:6%;'>"   .$tvpizzano[4]  ."</td></tr>" ;
 
}  //end for $vloop

} //endif for poslad.

} //endif

} //end sloop

/////////////////////////////////////table design for the search result
$resdst="<table border='1'>  <tr><th>date</th><th>dr amt</th><th>cr amt</th><th>Progressive total</th><th>dr. account</th><th>cr. account</th><th>Remarks</th></tr>";
$debitsumma=0;
$creditsumma=0;

//Grand summations for the search
$resds = $resds  
// ."<tr><td>"   ." "  . "</td>"
."<td>"   ."Balance with debit and credit summations"   ."</td>"

."<td style='text-align:right; width:5%;'>"    . $formacrdeeseditsummadees   ."</td>" 
  
   ."<td style='text-align:right; width:5%;'>"    . $formadebitsummadees   ."</td>"

."<td style='text-align:right;'>"    .$formabaldees  ."</td>"
 ."<td>"  ." "  ."</td></tr>";

$resdst = $resdst . $resds . "</table>" ;
echo $resdst;

if ($_GET[taoutput] =="y"){
$todate= date(dmy_hi); 
$filename= "accs" .$todate  .".doc";

//$filename="accs.doc";
file_put_contents($filename,     ( $resuallaccos3   ."\n\n\n"   .$trbaltab   ."\n\n\n"  .$resuincoexp3   ."\n\n\n"       .$resubsexp3)   );

} //endif for isset taoutput

?>
</body></html>

Is there any method/structure for each transaction to be entered in the txt file of transactions?

Ans: The structure is important, becausing we shall be using a mychoicefilename.txt as a sort of database. In a formal database we come across rows and columns in tables. Those who are familiar with DBMS, RDBMS, sqlite, mysqlite etc. know it.

To avoid the complexities of using databases, particularly when confidentiality and security are not important, we are using a simple txt file separated by delimiters, as database.

In our Manager, we are using '2 line feeds (double line spacing) to separate one record from another record. (Each transaction is taken as a record, and entered in double line spacing.)

Incomplete.

Wednesday, September 17, 2014

005 Geany Portable for linux OS users like Ubuntu

005 Geany Portable for linux OS users like Ubuntu
005 జీని పోర్టబుల్ --ఉబుంటు వంటి లైనక్స్ ఓ.ఎస్. లు వాడే వారి కొరకు
००५ जीनी पोर्टबुल -- उबुंटु आदी लैनक्स ओ.ऎस. उपयोग करने वालों के लिये.

The main benefit of using portables, is they need no installation. పోర్టబుల్ సాఫ్టవేర్ ను వాడటం లో ముఖ్య లాభం ఏమిటంటే వాటిని ఇన్స్టాల్ చేయనవసరం లేదు. पोर्टबुल साफ्टवेर उपयोग करने से मुख्य फाईदा यह है कि: उन को इनस्टाल करने का जरूरत नहीँ है।

I find that we may not be able to get GEDIT portable, but we can get Geany portable for Linux OS. నేను గమనించింది ఏమిటంటే, మనకు జీ ఎడిట్ పోర్టబుల్ లైనక్స్ లభించక పోవచ్చు కానీ, జీనీ పోర్టబుల్ లైనక్సు అప్లికేషన్ లభిస్తుంది. मै देखा हुँ कि: हमारे के लिये जीऎडिट पोर्टबुल लैनक्स नहीँ मिल् रहा है, परन्तु, जीनी पोरटबुल लैनक्स मिल रहा है।

Link for downloading. డౌన్ లోడ్ చేసుకోటానికి లింకు. डौनलोड करने के लिये लिंक: Click.

We can at present get get portable geany version 0.19.1. It is just 3.8 mb size. మనం ప్రస్తుతం జీనీ పోర్టబుల్ 0.19.1 ని మనం ఇక్కడ డౌన్ లోడ్ చేసుకోవచ్చు. वर्तमान में आज हम जीनी पोर्टबुल वॆर्षन 0.19.1 को डौनलोड कर सकते।

When they upload newer versions in this page, you can download them also. వాళ్ళు ఈ పేజీ లో ఇంకా కొత్త వెర్షన్ లను అప్ లోడ్ చేసినపుడు, మీరు ఈపేజీలో వాటిని డౌన్ లోడ్ చేసుకోవచ్చు. जब वे नये वॆर्षन अपलोड करेगे, तब आप नये वॆर्षन को भी डौन लोड कर सकते हैं।

One important strength of the above Geany Portable is we can make a Regex based search and replace, while in Gedit for Regex search, we need a separate plugin. జీనీ పోర్టబుల్ లో గొప్ప సుగుణం ఏమిటంటే మనం రెజెక్స్ ఆధారిత వెతకటం, మార్పిడీలు చేయటం తేలిక. అదే జీ ఎడిట్ లో అయితే మనం ప్రత్యేక ప్లగ్ ఇన్ ను డౌన్ లోడ్ చేసుకోవాలి. जीनी में एक सुगुण यह है कि: हम रॆजॆक्स आधारित खोज और स्थानभ्रंश (बदला) कर सकते। जीऎडिट मॆं हम अतिरिक्त प्लगिन डौनलोड करना आवस्य होता है।

In Geany, if we want, we can carry out find and replacement in the selected portion of the documents, instead of Replace All in the entire document, whereas in Gedit we cannot do it without special plugins. జీనీ లో మనకు కావాలంటే, దస్తావేజ్ లో , ఎన్నిక చేసిన ప్రదేశంలో మాత్రం అన్వేషణ-మార్పులను పూర్తిచేసుకోవచ్చు. జీఎడిట్ లో రీప్లేస్ ఆల్ మొత్తం డాక్యుమెంటుకు చేస్తానంటుంది. जीनी में, हम चाहे तो, खोज और भ्रंश सिर्फ चुना हुआ जगहों में कर सकते। जीऎडिट में रीप्लेस आल पूरे डाक्युमॆंट मॆं करना होगा।

Saturday, August 24, 2013

004 Sticky footer problem finally solved

Today's Picture:

For the last one year, I have been facing the problem of sticky footer at a sub-domain website of mine. To avoid the embarrassing situation of footer appearing in the middle of the page, I had to remove the footer and allow all the three dynamic columns (left, middle, right), which do not have fixed height.

I use the following layout:
Top one division with 100% width.
Next:
left div with width of approx.20%.
middle div starts at 21% with width of 59%.
right div starts at 81% with width of 18%.
All the columns have borders.
All the columns get their data from php/html files. Hence, their height varies. Giving a fixed height, and overflow-scroll, I used for sometime. But, somehow, it did not satisfy me.

Visiting numerous websites containing css support threads educated me, but could not solve my problem because of the burden of three dynamic divs.

Finally, today, I could solve the problem by using a very simple technique. For the benefit of my readers, I present it below.

Last column, last division in my above layout, usually gets the highest height. It starts at 81% margin-left, with 18% width, 1% border, ends at 100%.

Here I added the following style:

<div style='position:relative; overflow:auto; ' > Content.

</div>.

Now, the footer div:

<div style='width:100%; float:left; height:60px; background:#aaaaff;'>
content.
</div.>

All the divisions, have their position:absolute. Exception is the last and lengthiest right division.

You can also see this demo at alternate site: ayyo.x10.mx.

If the above technique does not work, probable reasons

Pl. check up all the previous divisions, whether they have proper closing tags and some other errors, which may be affecting their position, and float.

Friday, February 15, 2013

003 Geany or Gedit which is better?

Question: Geany or Gedit, which is better?

Latest answer added on 29.8.2018, after using both Geany and Gedit for about ten years:

In my pesonal view, the greatest merit of Geany over Gedit is, Geany's convenient and nearly unlimited additions to the Snippets.conf file. This Snippets file is something similar to 'Auto-complete' in MS Word. But Geany Snippets are more flexible and convenient than the Autocomplete in MS Word.

The Snippets file in Gedit requires identification of a hotkey for each snippet. As the availability of hotkeys will be limited, soon we get exhausted of the hotkeys. Adding snippets and hotkeys in Gedit is more complicated.
Previous answer given by me some years back: Gedit is the default text editor which we get with Ubuntu.
It is an excellent text editor, particularly for regex based searches and replacements.
But, I feel that, it is slow in saving large files.
It may, sometimes, hang on.
For editing codes such as html, javascript and php, gedit has good color combinations.

Geany on the other hand needs download.
sudo add-apt-repository ppa:geany-dev/ppa
sudo apt-get update
sudo apt-get update sudo apt-get install geany
sudo apt-get intall geany-plugins.

Geany is particularly convenient for handling very large-files. It saves almost instantly.

summary: For editing short-files, I prefer gedit. For editing-long-files, I prefer geany. For editing codes, I suggest gedit. For editing texts, I suggest geany.
How to avoid sudo every-time?
At the command-line, we have to type the following: sudo -i and press enter key. We have to give super-user password, when the system prompts. The terminal line will change from $ to #. User name will change to root.

Incomplete. More content will be added shortly.

Tuesday, January 29, 2013

002 Nautilus BETTER THAN filezilla

I am a linux-fan. Ubuntu flavor of linux. 10.10 version.
Tired of Windows concealing ways, I shifted to ubuntu about two years back.
I regularly depended on the command sudo apt-get install ... for installing new packages. It has never disappointed me for a long time.
use dual boot grub of ubuntu with windows xp : sometimes, I had some successes but failures were more. Windows used failed to boot and I had to reinstall. Every reinstall of windows ate the grub in my dev/sda, owing to intolerance of windows towards other operating systems. As re- and re- installations of Ubuntu were easier than windows, I re- and re- installed Ubuntu.
Reinstallations of Ubuntu were resulting in loss of many packages I got using apt-get install commands, getting deb files, and configuring tar files.
Recently, it seems that Ubuntu stopped supporting updates for 10.10 version. It also seems that they withdrew support for some repositories, which we could include with the command add-apt-repository ppa:., or by gediting source.list file.
Consequently, I found that it is frustrating to install packages like aptitude, gparted and filezilla or gftp. Downloading dependencies seems to be a heavy and costly affair. For example, for sudo apt-get install of gpartem, I get a command line reply message of needing to download 398 mbs of dependencies for the installation.
The same is the case with filezilla. Though, I downloaded the tar (zip in windows lingo) files of filezilla, and tried to configure and make files, I got error messages of missing dependencies.
I learnt over internet, that Nautilus file Manager, available with Ubuntu, by default is very useful.
Steps for using Nautilus:
Places. Desktop option. Desktop folder will appear. File Menu. Connect to Server option. Various choices appear. We type the ftp address, user-name, and password if any for logging into the ftp server (our host). When our root directory appears, uploading of files will only be a drag and drop / copy-paste affair.
Though Nautilus file manager, may miss some of the extra functionalities of filezilla, by and large it serves our purpose.

Added on 24th August 2013.

After working for several months with nautilus, I have come to a reasonable conclusion that it is better than filezilla. Though filezilla is free, Nautilus is more convenient because it comes free and as DEFAULT with ubuntu (I use ubuntu 10.10). Whenever we format and reinstall or reinstall ubuntu, we need not worry about getting filezilla.

Saturday, December 15, 2012

001 Introduction

TODAY'S PICTURE

Question: You already have about 66 blogs. Many of these blogs, do not have postings for the last several months. They have become nearly orphans, or uncared children. Why do you add one more blog?
Ans: I always felt that I should not add more blogs. But, I have developed an irresistable feeling today, that I must share my experiences with the information technology and computers, with my readers, so that some of the scripts I write here may save them from the pains and strains of re-discovering or rebuilding the Rome.

First of the first: I must express my sincere gratitude to hundreds of IT-computer guides and sharers, IT-computer free websites, who have worked as NEARLY SELF-LESS UNPAID TEACHERS of information technology.

I must make special mention of the Linux-Ubuntu-launchpad-debian-gnome-kubuntu (list incomplete) community who gave everything free of cost and open source. The offline and online computer world would have been miserable, in the absence of these divine Marxist-socialist souls (they might not have declared themselves so), having been abandoned to the rapacious Microsoft, Windows and the likes.

I must express my profound thanks to the creators of javascript and php scripts, and the apache server, all of which are free.

My presentations at this blog, most of the time, I foresee will mainly contain some javascripts and php scripts. I am a beginner and may be committing errors or not following the conventions of coding. Readers will please bear with me. I am not a professional. I am presenting these codes, more as an 'end-user' myself and not as an I.T. professional. Hence, an appeal for some allowances, leeways, margins and tolerances.

Nevertheless, free, frank, tough criticism is welcome, as long as obscene language is not used.

yb Computer MCQs, Programs, Scripts & Studies

Friday, February 15, 2019

007 An Online Clickable Multiple Choice Questions Quiz No.92153 on Computers and IT

MULTIPLE CHOICE QUESTIONS TEST No. 92153

Tuesday, August 28, 2018

006 Free php Script for a Personal Accounts Manager

Where is the script?

Question: Will the Script Work in Windows / Linux / Mac. ?

Is there any method/structure for each transaction to be entered in the txt file of transactions?

Wednesday, September 17, 2014

005 Geany Portable for linux OS users like Ubuntu

Saturday, August 24, 2013

004 Sticky footer problem finally solved

Friday, February 15, 2013

003 Geany or Gedit which is better?

Question: Geany or Gedit, which is better?

Latest answer added on 29.8.2018, after using both Geany and Gedit for about ten years:

Tuesday, January 29, 2013

002 Nautilus BETTER THAN filezilla

Saturday, December 15, 2012

001 Introduction