1<?php 2/** 3 * $Id: account.php,v 1.11 2003/03/26 08:31:23 courou Exp $ 4 * 5 * Author : courou@users.sourceforge.net 6 * Website : http://allreponse.ath.cx 7 * 8 * Support : http://sourceforge.net/projects/myphpmoney/ 9 * CVS : http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/myphpmoney/ 10 */ 11 12/** 13 * INCLUDE FILE 14 */ 15 require_once 'config/settings.inc.php'; 16 17/** 18 * ENTER IN THE SESSION OR BUILD THE LOGIN FORM 19 */ 20 if (SQL_VerifSession()) { 21 22/** 23 * IF NO ID ACCOUNT (DEFAULT ID) 24 */ 25 if (!isset($_POST['ID'])) $_POST['ID'] = SQL_IdAccount(''); 26 $name_account = SQL_NameAccount($_POST['ID']); 27 28/** 29 * DEFINE VARIABLE GLOBALS 30 */ 31 $PageOrder = 'account'; 32 $cont = array(); 33 $sum_spent = ''; 34 $sum_received = ''; 35 $ids_mods = ''; ## for recup the id account mod modif 36 $submit = ''; ## for recup the submit value (dupliquer) 37 $selectAccount = ''; ## For change this account 38 $affecters = ''; ## for depense or recette 39 $_MPM['BlockInclude'] = 0; ## for the include template 40 41 $_N_ID = SQL_RecupId(1); 42 $id_cat = SQL_RecupId(0); 43 $id_tiers = SQL_RecupId(4); 44 $ID_TIERS = SQL_SearchInThird(0,$_POST['ID']); 45 $_DATE = isset($_POST['date']) 46 ? ereg_replace('^([0-9]{1,2})-([0-9]{1,2})-([0-9]{2,4})$', '\3-\2-\1', $_POST['date']) 47 : ''; 48 $ID_COREL = isset($_POST['tiers']) ? SQL_SearchInThird(1,$_POST['tiers']) : ''; 49 50/** 51 * DEFINE VARIABLE 52 */ 53 if (!isset($_POST['opt'])) $_POST['opt'] = ''; 54 55/** 56 * FOR RELOAD DUPLIQ ACTION 57 */ 58 if ($_POST['opt'] != 'MODIF_THIS_ACCOUNT') { 59 $sess->unregister('sess_reload'); 60 } 61 62/** 63 * SWITCH ACTION (RENAME - ADD - DUPLIQUER) 64 */ 65 switch($_POST['opt']) { 66 67 ## UPDATE THE VALIDE IMAGE YES OR NOT 68 default : 69 if (isset($_POST['VALID_IMG']) && is_array($_POST['VALID_IMG'])) { 70 while(list($kobj,$vobj) = each($_POST['VALID_IMG'])) { 71 $hid = explode('|',$kobj); 72 73 $IdAcct = SQL_SearchIdCorel(1,$hid[0]); 74 if ($hid[1] == 0) { 75 if ($IdAcct > 1) { 76 SQL_UpdateAccount(0,'',1,'',1,$IdAcct); 77 } 78 SQL_UpdateAccount(0,'',1,'',1,$hid[0]); 79 } else if ($hid[1] == 1) { 80 81 if ($IdAcct > 1) { 82 SQL_UpdateAccount(0,'',0,'',1,$IdAcct); 83 } 84 SQL_UpdateAccount(0,'',0,'',1,$hid[0]); 85 } ## end of $hid[1] 86 } ## end of while 87 } ## end of is_isset && is_array() 88 89 ## DELETE THE ACCOUNT NUMBER 90 if (isset($_POST['SUPP_ACCOUNT'])) { 91 $val_del = explode('|',$_POST['SUPP_ACCOUNT']); 92 ## CORRELATION EXISTE 93 if ($val_del[1] == 1) { 94 $Corel = SQL_SearchIdCorel(1,$_POST['SUPP_ACCOUNT']); 95 $Compte_Corel = SQL_Search_AcctCorel(1,$Corel,1); 96 97 SQL_DeleteAccount(1,$Corel,'',0); 98 99 SQL_RecupSolde($Compte_Corel); 100 } 101 102 SQL_DeleteAccount(1,$val_del[0],'',0); 103 SQL_RecupSolde($_POST['ID']); 104 } ## end of isset($_POST['SUPP_ACCOUNT'] 105 break; 106 /** 107 * SWITCH -- ADD THE NEWS ACCOUNT OPERATION 108 */ 109 case 'ADD_ACCOUNT' : 110 if (($_POST['ID'] && $_POST['date'] && $_POST['cat'] && $_POST['paie'] && $_POST['affecter']) != '') { 111 112 if (isset($_POST['MOD_IF']) && is_array($_POST['MOD_IF']) && $_POST['MOD_IF']['0'] == $_VAR['DUPLIQ']) { 113 $submit = $_VAR['DUPLIQ']; ## DUPLIQ 114 } 115 116 /** 117 * THE VALUE ET NAME OF POST VARIABLE 118 */ 119 if ($_POST['affecter'] == 1) { $_RECETTE = 0; $_DEPENSE = $_POST['paie']; } 120 if ($_POST['affecter'] == 2) { $_DEPENSE = 0; $_RECETTE = $_POST['paie']; } 121 if ($_POST['cat'] == __PART_ID__) $_COREL = bcadd($_N_ID,1); else $_COREL = 0; 122 123 ## NEWS ENTRY FOR THE THIRD AND PART 124 if ($_POST['cat'] == __ANOTHER_ACCOUNT__) { 125 if (($_POST['news_cat'] && $_POST['news_tiers']) != '') { 126 127 $result = SQL_VerifPostAcct 128 ( 129 1, 130 bcsub($_N_ID,1), 131 0, 132 $_POST['R'], 133 $_POST['numero_id'], 134 $_DATE, 135 bcsub($id_cat,1), 136 bcsub($id_tiers,1), 137 $_POST['commentaires'], 138 $_DEPENSE, 139 $_RECETTE, 140 $_POST['ID'], 141 'NULL', 142 0 143 ); 144 145 if (!$result) { 146 $id_cat = SQL_BuildCat($_POST['news_cat'],$id_cat); 147 $id_tiers = SQL_BuildTiers($_POST['news_tiers'],$id_cat,$id_tiers); 148 149 if (isset($id_cat) && $id_cat != __PART_ID__) { 150 ## Inserer 151 SQL_InsertAccount 152 ( 153 $_N_ID, 154 $_POST['numero_id'], 155 1, 156 $_POST['R'], 157 $_DATE, 158 $id_cat, 159 $id_tiers, 160 $_COREL, 161 $_POST['commentaires'], 162 $_DEPENSE, 163 $_RECETTE, 164 $_POST['ID'], 165 0, 166 0 167 ); 168 169 ## Dupliquer 170 if ($submit == $_VAR['DUPLIQ']) { 171 SQL_InsertAccount 172 ( 173 bcadd($_N_ID,1), 174 $_POST['numero_id'], 175 1, 176 $_POST['R'], 177 $_DATE, 178 $id_cat, 179 $id_tiers, 180 $_COREL, 181 $_POST['commentaires'], 182 $_DEPENSE, 183 $_RECETTE, 184 $_POST['ID'], 185 0, 186 0 187 ); 188 } 189 SQL_RecupSolde($_POST['ID']); 190 } 191 } ## end of $result 192 193 } ## end of $_POST['news_cat'] && $_POST['news_tiers'] != '' 194 } ## end of of $_POST['cat'] == __ANOTHER_ACCOUNT__ 195 196 ## NEWS ENTRY FOR THE THIRD ONLY 197 else if ($_POST['tiers'] == __ANOTHER_ACCOUNT__) { 198 199 $result = SQL_VerifPostAcct 200 ( 201 1, 202 bcsub($_N_ID,1), 203 0, 204 $_POST['R'], 205 $_POST['numero_id'], 206 $_DATE, 207 $_POST['cat'], 208 bcsub($id_tiers,1), 209 $_POST['commentaires'], 210 $_DEPENSE, 211 $_RECETTE, 212 $_POST['ID'], 213 'NULL', 214 0 215 ); 216 if (!$result) { 217 $id_tiers = SQL_BuildTiers($_POST['news_tiers'],$_POST['cat'],$id_tiers); 218 219 ## Inserer 220 SQL_InsertAccount 221 ( 222 $_N_ID, 223 $_POST['numero_id'], 224 1, 225 $_POST['R'], 226 $_DATE, 227 $_POST['cat'], 228 $id_tiers, 229 $_COREL, 230 $_POST['commentaires'], 231 $_DEPENSE, 232 $_RECETTE, 233 $_POST['ID'], 234 0, 235 0 236 ); 237 238 ## Dupliquer 239 if ($submit == $_VAR['DUPLIQ']) { 240 SQL_InsertAccount 241 ( 242 bcadd($_N_ID,1), 243 $_POST['numero_id'], 244 1, 245 $_POST['R'], 246 $_DATE, 247 $_POST['cat'], 248 $id_tiers, 249 $_COREL, 250 $_POST['commentaires'], 251 $_DEPENSE, 252 $_RECETTE, 253 $_POST['ID'], 254 0, 255 0 256 ); 257 } 258 SQL_RecupSolde($_POST['ID']); 259 } ## end of !$result 260 261 } ## end of of $_POST['tiers'] == __ANOTHER_ACCOUNT__ 262 263 ## NO NEWS ENTRY FOR THIRD AND PART 264 else if ($_POST['cat'] != __ANOTHER_ACCOUNT__ || $_POST['tiers'] != __ANOTHER_ACCOUNT__) { 265 if ($_POST['cat'] == __PART_ID__) { 266 $result = SQL_VerifPostAcct 267 ( 268 1, 269 $_N_ID, 270 $_COREL, 271 $_POST['R'], 272 $_POST['numero_id'], 273 $_DATE, 274 $_POST['cat'], 275 $_POST['tiers'], 276 $_POST['commentaires'], 277 $_DEPENSE, 278 $_RECETTE, 279 $_POST['ID'], 280 'NULL', 281 1 282 ); 283 } else { 284 $result = SQL_VerifPostAcct 285 ( 286 1, 287 bcsub($_N_ID,1), 288 0, 289 $_POST['R'], 290 $_POST['numero_id'], 291 $_DATE, 292 $_POST['cat'], 293 $_POST['tiers'], 294 $_POST['commentaires'], 295 $_DEPENSE, 296 $_RECETTE, 297 $_POST['ID'], 298 'NULL', 299 0 300 ); 301 } 302 303 if (!$result) { 304 ## Inserer 305 SQL_InsertAccount 306 ( 307 $_N_ID, 308 $_POST['numero_id'], 309 1, 310 $_POST['R'], 311 $_DATE, 312 $_POST['cat'], 313 $_POST['tiers'], 314 $_COREL, 315 $_POST['commentaires'], 316 $_DEPENSE, 317 $_RECETTE, 318 $_POST['ID'], 319 0, 320 0 321 ); 322 323 ## Dupliquer 324 if ($submit == $_VAR['DUPLIQ']) { 325 if ($_POST['cat'] == __PART_ID__) { 326 $id_account = bcadd($_N_ID,2); 327 $id_corel = bcadd($_COREL,2); 328 } else { 329 $id_account = bcadd($_N_ID,1); 330 $id_corel = 0; 331 } 332 333 SQL_InsertAccount 334 ( 335 $id_account, 336 $_POST['numero_id'], 337 1, 338 $_POST['R'], 339 $_DATE, 340 $_POST['cat'], 341 $_POST['tiers'], 342 $id_corel, 343 $_POST['commentaires'], 344 $_DEPENSE, 345 $_RECETTE, 346 $_POST['ID'], 347 0, 348 0 349 ); 350 } 351 SQL_RecupSolde($_POST['ID']); 352 353 if ($_POST['cat'] == __PART_ID__) { 354 ## Inserer 355 SQL_InsertAccount 356 ( 357 $_COREL, 358 $_POST['numero_id'], 359 1, 360 $_POST['R'], 361 $_DATE, 362 $_POST['cat'], 363 $ID_TIERS, 364 $_N_ID, 365 $_POST['commentaires'], 366 $_RECETTE, 367 $_DEPENSE, 368 $ID_COREL, 369 0, 370 0 371 ); 372 373 ## Dupliquer 374 if ($submit == $_VAR['DUPLIQ']) { 375 SQL_InsertAccount 376 ( 377 bcadd($_COREL,2), 378 $_POST['numero_id'], 379 1, 380 $_POST['R'], 381 $_DATE, 382 $_POST['cat'], 383 $ID_TIERS, 384 bcadd($_N_ID,2), 385 $_POST['commentaires'], 386 $_RECETTE, 387 $_DEPENSE, 388 $ID_COREL, 389 0, 390 0 391 ); 392 } 393 SQL_RecupSolde($ID_COREL); 394 } ## end of $_POST['cat'] == __PART_ID__ 395 } ## end of $result 396 397 } ## end of $_POST['cat'] != __ANOTHER_ACCOUNT__ || .... 398 } ## end of all $_POST != '' 399 break; 400 /** 401 * SWITCH -- MODIF THE ACCOUNT OPERATION 402 */ 403 case 'MODIF_THIS_ACCOUNT': 404 if (isset($_POST['MOD_IF']) && is_array($_POST['MOD_IF']) && !$sess->is_registered('sess_reload')) { 405 406 while(list($kmods,$sub) = each($_POST['MOD_IF'])) { 407 $ids_mods = $kmods; ## MODIF 408 $submit = $sub; ## DUPLIQ 409 } 410 411 ## For change this account 412 if (isset($_POST['MODIF_IF_ACCOUNT']) && $_POST['MODIF_IF_ACCOUNT'] != '' && isset($_POST['cat']) 413 && $_POST['cat'] != __PART_ID__ && isset($_POST['ID']) && $_POST['ID'] != $_POST['MODIF_IF_ACCOUNT']) { 414 $selectAccount = $_POST['MODIF_IF_ACCOUNT']; 415 } 416 417 if ($_POST['affecter'] == 1) { $_RECETTE = 0; $_DEPENSE = $_POST['paie']; } 418 if ($_POST['affecter'] == 2) { $_DEPENSE = 0; $_RECETTE = $_POST['paie']; } 419 420 $valid_db->query 421 ( 422 "SELECT NUMID,VALID_OP,DATE_FORMAT(DATES,'%d-%m-%Y') 423 AS DATES,THIRD,CAT,COMMENTS,OUT,IMP,COREL 424 FROM ".$_MPM['table'][1]." 425 WHERE TEMPID=1 426 AND OPID='$ids_mods' 427 AND USERID='$sess_pid' 428 AND ACCOUNT='".$_POST['ID']."'" 429 ); 430 431 if ($valid_db->num_rows() == 1) { 432 $valid_db->next_record(); 433 434 if ($_POST['R'] != $valid_db->f('VALID_OP')) 435 $cont[] .= "VALID_OP='".$_POST['R']."'"; 436 if ($_POST['date'] != $valid_db->f('DATES')) 437 $cont[] .= "DATES='$_DATE'"; 438 if ($_POST['commentaires'] != $valid_db->f('COMMENTS')) 439 $cont[] .= "COMMENTS='".$_POST['commentaires']."'"; 440 if ($_POST['cat'] == __PART_ID__ && $valid_db->f('CAT') != __PART_ID__) { 441 $cont[] .= "COREL='".bcadd($_N_ID,1)."'"; 442 } else if ($valid_db->f('CAT') == __PART_ID__) { 443 if ($_POST['cat'] == __PART_ID__) { 444 $cont[] .= "COREL='".$valid_db->f('COREL')."'"; 445 446 ## Modifier 447 SQL_UpdateAllAccount 448 ( 449 $_POST['R'], 450 $_POST['numero_id'], 451 $_DATE, 452 $ID_TIERS, 453 $_DEPENSE, 454 $_RECETTE, 455 $ID_COREL, 456 $_POST['commentaires'], 457 '', 458 1, 459 $valid_db->f('COREL') 460 ); 461 462 ## Dupliquer 463 if ($submit == $_VAR['DUPLIQ']) { 464 SQL_InsertAccount 465 ( 466 $_N_ID, 467 $_POST['numero_id'], 468 1, 469 $_POST['R'], 470 $_DATE, 471 $_POST['cat'], 472 $_POST['tiers'], 473 bcadd($_N_ID,1), 474 $_POST['commentaires'], 475 $_DEPENSE, 476 $_RECETTE, 477 $_POST['ID'], 478 0, 479 0 480 ); 481 } ## end of if ($submit == $_VAR['DUPLIQ']) 482 SQL_RecupSolde($ID_COREL); 483 } else { 484 $cont[] .= "COREL='0'"; 485 if ($ID_COREL == '') $ID_COREL = SQL_SearchInThird(1,$valid_db->f('THIRD')); 486 487 SQL_DeleteAccount(1,$valid_db->f('COREL'),'',0); 488 SQL_RecupSolde($ID_COREL); 489 } 490 } 491 else { 492 $cont[] .= "COREL='0'"; 493 } 494 if ($_POST['cat'] != $valid_db->f('CAT')) { 495 if ($_POST['cat'] == __PART_ID__ && $valid_db->f('CAT') != __PART_ID__) { 496 $cont[] .= "CAT='".$_POST['cat']."'"; 497 498 ## Modifier 499 SQL_InsertAccount 500 ( 501 bcadd($_N_ID,1), 502 $_POST['numero_id'], 503 1, 504 $_POST['R'], 505 $_DATE, 506 $_POST['cat'], 507 $ID_TIERS, 508 $_N_ID, 509 $_POST['commentaires'], 510 $_RECETTE, 511 $_DEPENSE, 512 $ID_COREL, 513 0, 514 0 515 ); 516 517 ## Dupliquer 518 if ($submit == $_VAR['DUPLIQ']) { 519 SQL_InsertAccount 520 ( 521 bcadd($_N_ID,3), 522 $_POST['numero_id'], 523 1, 524 $_POST['R'], 525 $_DATE, 526 $_POST['cat'], 527 $ID_TIERS, 528 bcadd($_N_ID,2), 529 $_POST['commentaires'], 530 $_RECETTE, 531 $_DEPENSE, 532 $ID_COREL, 533 0, 534 0 535 ); 536 } ## end of if ($submit == $_VAR['DUPLIQ']) 537 SQL_RecupSolde($ID_COREL); 538 } else if ($_POST['cat'] == __ANOTHER_ACCOUNT__) { 539 $cont[] .= "CAT='".SQL_BuildCat($_POST['news_cat'],$id_cat)."'"; 540 $id_tiers = SQL_BuildTiers($_POST['news_tiers'],$id_cat,$id_tiers); 541 $cont[] .= "THIRD='$id_tiers'"; 542 } else { 543 $cont[] .= "CAT='".$_POST['cat']."'"; 544 } 545 } 546 if (isset($_POST['tiers']) && $_POST['tiers'] != $valid_db->f('THIRD')) { 547 if ($_POST['tiers'] == __ANOTHER_ACCOUNT__) { 548 $id_tiers = SQL_BuildTiers($_POST['news_tiers'],$_POST['cat'],$id_tiers); 549 $cont[] .= "THIRD='$id_tiers'"; 550 } 551 else if (isset($_POST['tiers'])) { 552 $cont[] .= "THIRD='".$_POST['tiers']."'"; 553 } 554 } 555 556 if ($valid_db->f('IMP') == 0) $paies = $valid_db->f('OUT'); 557 else if ($valid_db->f('OUT') == 0) $paies = $valid_db->f('IMP'); 558 559 if ($_POST['paie'] != $paies) { 560 561 if ($_POST['affecter'] == 1) { 562 $cont[] .= "OUT='".$_POST['paie']."'"; 563 $cont[] .= "IMP='0'"; 564 } else if ($_POST['affecter'] == 2) { 565 $cont[] .= "OUT='0'"; 566 $cont[] .= "IMP='".$_POST['paie']."'"; 567 } 568 } 569 if ($_POST['affecter'] == 1 && $valid_db->f('OUT') == 0) { 570 $cont[] .= "IMP='0'"; 571 $cont[] .= "OUT='".$_POST['paie']."'"; 572 } else if ($_POST['affecter'] == 2 && $valid_db->f('IMP') == 0) { 573 $cont[] .= "OUT='0'"; 574 $cont[] .= "IMP='".$_POST['paie']."'"; 575 } 576 577 if (isset($_POST['numero_id']) && $_POST['numero_id'] != $valid_db->f('NUMID')) { 578 $cont[] .= "NUMID='".$_POST['numero_id']."'"; 579 } else { 580 $cont[] .= "NUMID='".$valid_db->f('NUMID')."'"; 581 } 582 583 ## Change this operation for the new account 584 if ($selectAccount != '') $cont[] .= "ACCOUNT='".$selectAccount."'"; 585 586 if (sizeof($cont) > 0) $liste = join($cont," , "); 587 588 if ($_POST['cat'] != '' && $valid_db->f('CAT') == __PART_ID__) { 589 590 ## Modifier 591 SQL_UpdateAccount(8,$liste,'','',1,$ids_mods); 592 593 ## Dupliquer 594 if ($submit == $_VAR['DUPLIQ']) { 595 SQL_InsertAccount 596 ( 597 bcadd($_N_ID,1), 598 $_POST['numero_id'], 599 1, 600 $_POST['R'], 601 $_DATE, 602 $_POST['cat'], 603 $ID_TIERS, 604 $_N_ID, 605 $_POST['commentaires'], 606 $_RECETTE, 607 $_DEPENSE, 608 $ID_COREL, 609 0, 610 0 611 ); 612 } ## end of if ($submit == $_VAR['DUPLIQ']) 613 SQL_RecupSolde($_POST['ID']); 614 } 615 else if ($_POST['cat'] == __PART_ID__ && $valid_db->f('CAT') != __PART_ID__) { 616 617 ## Modifier 618 SQL_UpdateAccount(7,$liste,$_N_ID,$_POST['ID'],1,$ids_mods); 619 620 ## Dupliquer 621 if ($submit == $_VAR['DUPLIQ']) { 622 SQL_InsertAccount 623 ( 624 bcadd($_N_ID,2), 625 $_POST['numero_id'], 626 1, 627 $_POST['R'], 628 $_DATE, 629 $_POST['cat'], 630 $_POST['tiers'], 631 bcadd($_N_ID,3), 632 $_POST['commentaires'], 633 $_DEPENSE, 634 $_RECETTE, 635 $_POST['ID'], 636 0, 637 0 638 ); 639 } ## end of if ($submit == $_VAR['DUPLIQ']) 640 SQL_RecupSolde($_POST['ID']); 641 } 642 else { 643 644 ## Modifier 645 SQL_UpdateAccount(6,$liste,'',$_POST['ID'],1,$ids_mods); 646 if ($selectAccount != '') SQL_RecupSolde($_POST['ID']); 647 648 ## Change this operation for the new account 649 ## This place is important (must be after the SQL_UpdateAccount) 650 if ($selectAccount != '') { 651 $_POST['ID'] = $selectAccount; 652 $name_account = SQL_NameAccount($_POST['ID']); 653 } 654 655 ## Dupliquer 656 if ($submit == $_VAR['DUPLIQ']) { 657 SQL_InsertAccount 658 ( 659 $_N_ID, 660 $_POST['numero_id'], 661 1, 662 $_POST['R'], 663 $_DATE, 664 isset($_POST['cat']) && $_POST['cat'] != __ANOTHER_ACCOUNT__ ? $_POST['cat'] : $id_cat, 665 isset($_POST['tiers']) && $_POST['tiers'] != __ANOTHER_ACCOUNT__ ? $_POST['tiers'] : $id_tiers, 666 0, 667 $_POST['commentaires'], 668 $_DEPENSE, 669 $_RECETTE, 670 $_POST['ID'], 671 0, 672 0 673 ); 674 } ## end of if ($submit == $_VAR['DUPLIQ']) 675 SQL_RecupSolde($_POST['ID']); 676 } 677 } ## end of if ($valid_db->num_rows() == 1) 678 679 $sess_reload = 1; 680 $sess->register('sess_reload'); 681 } ## end of if (isset($_POST['MOD_IF']) && !$sess->is_registered('sess_reload')) 682 683 ## RETURN DEFAULT VALUE FOR THE FORM -- NOT RELOAD SO NECESSARY 684 $_POST['opt'] = 'ADD_ACCOUNT'; 685 break; 686 } ## end of switch $opt 687 688/** 689 * BUILD THE HEADER (THIS PLACE IS IMPORTANTE FOR MENU SELECT ADD ACCOUNT) 690 */ 691 XHTML_header(1,1,1,1,0,0,0,1); 692 693/** 694 * RECUP THE ID FOR THE MODIFIED ACCOUNT OPERATION 695 */ 696 if (isset($_POST['MODIF_ACCOUNT']) && is_array($_POST['MODIF_ACCOUNT'])) { 697 while(list($kmod) = each($_POST['MODIF_ACCOUNT'])) $id_mod = $kmod; 698 } 699 700/** 701 * BUILD DETAIL LIST FOR THE ACCOUNT LIST 702 */ 703 if (isset($_POST['date'])) $_RECUP = explode('-',$_POST['date']); 704 if (isset($_RECUP) && is_array($_RECUP)) $The_mois = "$_RECUP[1]-$_RECUP[2]"; 705 else if (!isset($_POST['The_mois']) || $_POST['The_mois'] == '') $The_mois = date('m-Y', time()); 706 else $The_mois = $_POST['The_mois']; 707 708 if (!isset($_POST['ID'])) $_POST['ID'] = SQL_IdAccount(''); 709 if ($_POST['opt'] == '') $_POST['opt'] = 'ADD_ACCOUNT'; 710 711/** 712 * SQL ORDER BY ... ASC ... DESC 713 */ 714 SQL_Orderby($PageOrder,1); 715 if (isset($_POST['order1'][$PageOrder]) && ereg("_",$_POST['order1'][$PageOrder])) { 716 $this_order = explode("_",$_POST['order1'][$PageOrder]); 717 if ($this_order[1] == 0) $order = $this_order[0]; 718 if (!isset($order)) $order = 'asc'; 719 } else { 720 $order = 'asc'; 721 } 722 723/** 724 * TITLE FOR ACCOUNT NAME 725 */ 726 printf("\n<h1 class=\"centerColor\">%s [%s] %s</h1>\n",$_VAR['LANG_ACCOUNT_4'],$name_account,XHTML_OPEN_CLOSE()); 727 728/** 729 * ADD THE NEW OPERATE 730 */ 731 if ($order == 'desc') include_once $_MPM['file_newop']; else include_once $_MPM['file_listop']; 732 733/** 734 * SEPARATOR HR 735 */ 736 echo "\n<div id=\"LayerTable2\" class=\"centerhr\"><div class=\"blockhr2\"><hr /></div><br /></div>\n"; 737 738/** 739 * LIST FOR OPERATE 740 */ 741 if ($order == 'desc') include_once $_MPM['file_listop']; else include_once $_MPM['file_newop']; 742 743 } else { 744 XHTML_DisplayLogin(); 745 } ## end if (SQL_VerifSession()) 746/** 747 * BUILD THE FOOTER 748 */ 749 XHTML_footer();