Jump to content

scarezekiel

Members
  • Posts

    70
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

scarezekiel's Achievements

Member

Member (2/5)

0

Reputation

  1. Im trying to implement this extension but I seem dont know how to do it.. Can any Yii gurus help me.. im trying to use the extension eexcelview.. i need a button on my admin page that can export the results to excel this is my controller <?php class MemberController extends Controller { /** * @var string the default layout for the views. Defaults to '//layouts/column2', meaning * using two-column layout. See 'protected/views/layouts/column2.php'. */ public $layout='//layouts/column2'; /** * @return array action filters */ public function filters() { return array( 'accessControl', // perform access control for CRUD operations ); } /** * Specifies the access control rules. * This method is used by the 'accessControl' filter. * @return array access control rules */ public function accessRules() { return array( array('allow', // allow admin user to perform 'admin' and 'delete' actions 'actions'=>array('admin','view','loadImage'), 'users'=>array(@AuthorizationController::getRights('member', 'canview')), ), array('allow', // allow admin user to perform 'admin' and 'delete' actions 'actions'=>array('create'), 'users'=>array(@AuthorizationController::getRights('member', 'cancreate')), ), array('allow', // allow admin user to perform 'admin' and 'delete' actions 'actions'=>array('delete'), 'users'=>array(@AuthorizationController::getRights('member', 'candelete')), ), array('allow', // allow admin user to perform 'admin' and 'delete' actions 'actions'=>array('update'), 'users'=>array(@AuthorizationController::getRights('member', 'canupdate')), ), array('deny', // deny all users 'users'=>array('*'), ), ); } /** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionView($id) { $this->render('view',array( 'model'=>$this->loadModel($id), )); } /** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model=new member; // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if(isset($_POST['member'])) { $model->attributes=$_POST['member']; /* if(!empty($_FILES['member']['tmp_name']['binaryfile'])) { $file = CUploadedFile::getInstance($model,'binaryfile'); $model->filename = $file->name; $model->filetype = $file->type; $fp = fopen($file->tempName, 'r'); $content = fread($fp, filesize($file->tempName)); fclose($fp); $model->binaryfile = $content; }*/ if($model->save()) { $this->redirect(array('view','id'=>$model->id)); } } $this->render('create',array( 'model'=>$model, )); } /** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function actionUpdate($id) { $model=$this->loadModel($id); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if(isset($_POST['member'])) { $model->attributes=$_POST['member']; ///$file = CUploadedFile::getInstance($model,'binaryfile'); //$model->remark = $file; // if(!empty($_FILES['member']['tmp_name']['binaryfile'])) // { //$file = CUploadedFile::getInstance($model,'binaryfile'); /* if( $file !== null ) { $model->filename = $file->name; $model->filetype = $file; $fp = fopen($file->tempName, 'r'); $content = fread($fp, filesize($file->tempName)); fclose($fp); $model->binaryfile = $content; }*/ // } // $model->user = Yii::app()->user->id; if($model->save()) { $this->redirect(array('view','id'=>$model->id)); } } $this->render('update',array( 'model'=>$model, )); } /** * Deletes a particular model. * If deletion is successful, the browser will be redirected to the 'admin' page. * @param integer $id the ID of the model to be deleted */ public function actionDelete($id) { if(Yii::app()->request->isPostRequest) { // we only allow deletion via POST request $this->loadModel($id)->delete(); // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser if(!isset($_GET['ajax'])) $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin')); } else throw new CHttpException(400,'Invalid request. Please do not repeat this request again.'); } /** * Lists all models. */ public function actionIndex() { $dataProvider=new CActiveDataProvider('member'); $this->render('index',array( 'dataProvider'=>$dataProvider, )); } /** * Manages all models. */ public function actionAdmin() { $model=new member('search'); $model->unsetAttributes(); // clear any default values if(isset($_GET['member'])) $model->attributes=$_GET['member']; $this->render('admin',array( 'model'=>$model, )); } /** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model=member::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; } /** * Performs the AJAX validation. * @param CModel the model to be validated */ protected function performAjaxValidation($model) { if(isset($_POST['ajax']) && $_POST['ajax']==='member-form') { echo CActiveForm::validate($model); Yii::app()->end(); } } public function actionloadImage($id) { $model=$this->loadModel($id); $this->renderPartial('picture', array( 'model'=>$model )); } } this is my admin page <?php $this->breadcrumbs=array( 'Member Profile', 'Manage Member', ); $this->menu=array( //array('label'=>'List member', 'url'=>array('index')), array('label'=>'Create Member', 'url'=>array('create')), ); Yii::app()->clientScript->registerScript('search', " $('.search-button').click(function(){ $('.search-form').toggle(); return false; }); $('.search-form form').submit(function(){ $.fn.yiiGridView.update('member-grid', { data: $(this).serialize() }); return false; }); "); ?> <h1>Manage Members</h1> <p> You may optionally enter a comparison operator (<b><</b>, <b><=</b>, <b>></b>, <b>>=</b>, <b><></b> or <b>=</b>) at the beginning of each of your search values to specify how the comparison should be done. </p> <?php echo CHtml::link('Advanced Search','#',array('class'=>'search-button')); ?> <div class="search-form" style="display:none"> <?php $this->renderPartial('_search',array( 'model'=>$model, )); ?> </div><!-- search-form --> <?php $this->widget('zii.widgets.grid.CGridView', array( 'id'=>'member-grid', 'dataProvider'=>$model->search(), 'filter'=>$model, 'columns'=>array( //'eno', // array( 'name'=>'membertypeid', 'value'=>'$data->membertype->code', 'htmlOptions'=>array('width'=>'40px'), ), array( 'name'=>'membertypeid', 'value'=>'$data->membertype->code', //'value' => '$data->ismassbilling?Yii::t(\'app\',\'Yes\'):Yii::t(\'app\', \'No\')', 'filter' => array('AF' => Yii::t('app', 'AF'), 'CREN' => Yii::t('app', 'CR'),'OM' => Yii::t('app', 'OM')), 'htmlOptions'=>array('width'=>'80px'), ), array( 'name'=>'membercode', 'value'=>'$data->membercode', 'htmlOptions'=>array('width'=>'70px'), ), array( 'name'=>'name', 'value'=>'$data->name', 'htmlOptions'=>array('width'=>'200px'), ), array( 'name'=>'icno', 'value'=>'$data->icno', 'htmlOptions'=>array('width'=>'150px'), ), //'passportno', array( 'name'=>'state', 'value'=>'$data->state','htmlOptions'=>array('width'=>'50px'), ), array( 'name'=>'companyid', 'value'=>'$data->company->companyname','htmlOptions'=>array('width'=>'120px'), ), // array( 'name'=>'statusid', 'value'=>'$data->status->statusid', ), array( 'name'=>'statusid', 'value'=>'$data->status->description','htmlOptions'=>array('width'=>'50px'), ), /* 'id', 'joineddate', 'address1', 'address2', 'postcode', 'city', 'country', 'mobile1', 'mobile2', 'mobile3', 'tel1', 'tel2', 'tel3', 'fax1', 'fax2', 'fax3', 'email1', 'email2', 'email3', 'remark', 'picture', 'createdby', 'createddate', 'modifiedby', 'modifieddate', */ array ( 'class'=>'CButtonColumn', 'template'=>'{billing}{payment}{paymenthistory} {image}{status} {view}{update}{delete}', 'htmlOptions'=>array('width'=>'300px'), 'buttons'=>array ( 'billing' => array ( 'label'=>'Billing', 'imageUrl'=>Yii::app()->request->baseUrl.'/themes/shadow_dancer/images/small_icons/invoice.png', 'url'=>'"../billing/admin/".$data->id', // 'options'=>array('target'=>'_blank'), ), 'payment' => array ( 'label'=>'Payment', 'imageUrl'=>Yii::app()->request->baseUrl.'/themes/shadow_dancer/images/small_icons/bag.png', 'url'=>'"../receivableledger/admin/".$data->id', // 'options'=>array('target'=>'_blank'), ), 'paymenthistory' => array ( 'label'=>'Billing & Payment History', 'imageUrl'=>Yii::app()->request->baseUrl.'/themes/shadow_dancer/images/small_icons/historyp.png', 'url'=>'"../vwmember/view/".$data->id', // 'options'=>array('target'=>'_blank'), ), 'image' => array ( 'label'=>'Picture', 'imageUrl'=>Yii::app()->request->baseUrl.'/themes/shadow_dancer/images/small_icons/page_white_picture.png', 'url'=>'"../memberpicture/update/".$data->id', // 'options'=>array('target'=>'_blank'), ), 'status' => array ( 'label'=>'Status Lookup', 'imageUrl'=>Yii::app()->request->baseUrl.'/themes/shadow_dancer/images/small_icons/page_white_star.png', 'url'=>'"../memberstatus/admin/".$data->id', // 'options'=>array('target'=>'_blank'), ), ), ), ), )); ?>
  2. Im an amateur.. anyone can help me on this yii framework forms.. i cant attach a photo of it.. keep failing to upload. this is the code I need (tel1,tel2,tel3) (fax1,fax2,fax3) to be on the same row.. I tried to put them on the same <div>. Doesn't work. <link rel="stylesheet" type="text/css" href="/erp/css/tabs/tabs.css" media="screen, projection" /> <div class="form"> <?php $form=$this->beginWidget('CActiveForm', array( 'id'=>'member-form', 'enableAjaxValidation'=>false, )); ?> <p class="note">Fields with <span class="required">*</span> are required.</p> <?php echo $form->errorSummary($model); ?> <ol id="toc"> <li><a href="#page-1"><span>General</span></a></li> <li><a href="#page-2"><span>Address</span></a></li> </ol> <div class="content" id="page-1"> <div class="row"> <?php echo $form->labelEx($model,'membertypeid'); ?> <?php echo $form->textField($model,'membertypeid'); ?> <?php echo $form->error($model,'membertypeid'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'memberid'); ?> <?php echo $form->textField($model,'memberid',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'memberid'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'eno'); ?> <?php echo $form->textField($model,'eno',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'eno'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'memberstatusid'); ?> <?php echo $form->textField($model,'memberstatusid'); ?> <?php echo $form->error($model,'memberstatusid'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'joineddate'); ?> <?php echo $form->textField($model,'joineddate'); ?> <?php echo $form->error($model,'joineddate'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'name'); ?> <?php echo $form->textField($model,'name',array('size'=>60,'maxlength'=>255)); ?> <?php echo $form->error($model,'name'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'icno'); ?> <?php echo $form->textField($model,'icno',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'icno'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'passportno'); ?> <?php echo $form->textField($model,'passportno',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'passportno'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'companyid'); ?> <?php echo $form->textField($model,'companyid'); ?> <?php echo $form->error($model,'companyid'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'remark'); ?> <?php echo $form->textField($model,'remark',array('size'=>60,'maxlength'=>255)); ?> <?php echo $form->error($model,'remark'); ?> </div> </div> <div class="content" id="page-2"> <div class="row"> <?php echo $form->labelEx($model,'address1'); ?> <?php echo $form->textField($model,'address1',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'address1'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'address2'); ?> <?php echo $form->textField($model,'address2',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'address2'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'postcode'); ?> <?php echo $form->textField($model,'postcode',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'postcode'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'city'); ?> <?php echo $form->textField($model,'city',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'city'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'state'); ?> <?php echo $form->textField($model,'state',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'state'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'country'); ?> <?php echo $form->textField($model,'country',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'country'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'mobile1'); ?> <?php echo $form->textField($model,'mobile1',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'mobile1'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'mobile2'); ?> <?php echo $form->textField($model,'mobile2',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'mobile2'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'mobile3'); ?> <?php echo $form->textField($model,'mobile3',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'mobile3'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'tel1'); ?> <?php echo $form->textField($model,'tel1',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'tel1'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'tel2'); ?> <?php echo $form->textField($model,'tel2',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'tel2'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'tel3'); ?> <?php echo $form->textField($model,'tel3',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'tel3'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'fax1'); ?> <?php echo $form->textField($model,'fax1',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'fax1'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'fax2'); ?> <?php echo $form->textField($model,'fax2',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'fax2'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'fax3'); ?> <?php echo $form->textField($model,'fax3',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'fax3'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'email1'); ?> <?php echo $form->textField($model,'email1',array('size'=>60,'maxlength'=>255)); ?> <?php echo $form->error($model,'email1'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'email2'); ?> <?php echo $form->textField($model,'email2',array('size'=>60,'maxlength'=>255)); ?> <?php echo $form->error($model,'email2'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'email3'); ?> <?php echo $form->textField($model,'email3',array('size'=>60,'maxlength'=>255)); ?> <?php echo $form->error($model,'email3'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'picture'); ?> <?php echo $form->textField($model,'picture'); ?> <?php echo $form->error($model,'picture'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'createdby'); ?> <?php echo $form->textField($model,'createdby',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'createdby'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'createddate'); ?> <?php echo $form->textField($model,'createddate'); ?> <?php echo $form->error($model,'createddate'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'modifiedby'); ?> <?php echo $form->textField($model,'modifiedby',array('size'=>60,'maxlength'=>100)); ?> <?php echo $form->error($model,'modifiedby'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'modifieddate'); ?> <?php echo $form->textField($model,'modifieddate'); ?> <?php echo $form->error($model,'modifieddate'); ?> </div> </div> <script type="text/javascript" src="/erp/css/tabs/activatables.js"></script> <script type="text/javascript"> activatables('page', ['page-1', 'page-2']); </script> <div class="row buttons"> <?php echo CHtml::submitButton($model->isNewRecord ? 'Create' : 'Save'); ?> </div> <?php $this->endWidget(); ?> </div><!-- form -->
  3. i dont know what to code on * to make it work.. if ($isvoid == 1) { (*dont display data) } else { (*display data) }
  4. okay so i have like 4 datas in my db. but it only shows 1 in the page..how to fix this <?php require("html2fpdf.php"); $description = trim($_POST[district]); $server = ''; $username = ''; $password = ''; $database_name=''; $dbconn = mysql_connect($server, $username,$password,false) or die("Could not establish connection"); mysql_select_db($database_name, $dbconn) or die ("Could not select database"); if (!$dbconn) { die('Something went wrong while connecting to MSSQL'); } ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title></title> </head> <body> <? $query="SELECT * FROM tblaccassetregister"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { $accassetgroupid = $row['accassetgroupid']; $assetcode = $row['assetcode']; $description = $row['description']; $purchaseprice = $row['purchaseprice']; $purchasedate = $row['purchasedate']; $serialno = $row['serialno']; $locationid = $row['locationid']; } ?> <table style="text-align: left; width: 715px; height: 32px;" border="0" cellpadding="2" cellspacing="2"> <tbody> <tr> <th align="left" colspan="2" style="font-style: italic;">Asset Group :</th> <? echo "<td align='left'>$accassetgroupid</td>"; ?> </tr> <tr> <th align="left" colspan="2" style="font-style: italic;">Description :</th> <? echo "<td align='left'>$description</td>"; ?> </tr> <tr> <td bgcolor="#00000" height="1px" colspan="5" rowspan="1"></td> <td bgcolor="#00000" height="1px" colspan="5" rowspan="1"></td> </tr> <br /> <tr class="even"> <th align="left" colspan="2" style="font-style: italic;">Asset Code :</th> <? echo "<td align='left' colspan='3'>$assetcode</td>"; ?> <th align="left" colspan="2" style="font-style: italic;">Purchase Date :</th> <? echo "<td align='left'>$purchasedate</td>"; ?> </tr> <tr class="odd"> <th align="left" colspan="2" style="font-style: italic;">Description :</th> <? echo "<td align='left' colspan='3'>$description</td>"; ?> <th align="left" colspan="2" style="font-style: italic;">Purchase Price :</th> <? echo "<td align='left'>$purchaseprice</td>"; ?> </tr> <tr class="even"> <th align="left" colspan="2" style="font-style: italic;">Location :</th> <? echo "<td align='left'>$locationid</td>"; ?> <th align="left" colspan="2" style="font-style: italic;"></th> <th align="left" colspan="2" style="font-style: italic;">Total Cost :</th> <? echo "<td align='left'>$purchaseprice</td>"; ?> </tr> </tbody> </table> <br> </body> </html> <?php $var = ob_get_clean(); $pdf = new HTML2FPDF('P', 'mm', 'Letter'); $pdf->AddPage(); $pdf->WriteHTML($var); $pdf->Output('test.pdf', 'I'); ?> i tried to attach a photo of it but dont know why this site cant upload it.
  5. scarezekiel

    help

    photo explains all... <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>confidential - Property Development</title> <link href="css/templates.css" rel="stylesheet" type="text/css" /> <link href="css/style.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" /> <script src="js/prototype.js" type="text/javascript"></script> <script src="js/scriptaculous.js?load=effects" type="text/javascript"></script> <script src="js/lightbox.js" type="text/javascript"></script> <style type="text/css"> html, body { margin:0; padding:0; } a:link { text-decoration: none; } a:visited { text-decoration: none; } a:hover { text-decoration: none; } a:active { text-decoration: none; } body,td,th { font-family: Arial, Helvetica, sans-serif; } </style> </head> <body> <div id="body60"> <span class="class1"> <link rel="stylesheet" type="text/css" href="nav/nav.css" /> <script src="nav/stuHover.js" type="text/javascript"></script> <ul id="nav"> <li><a href="contactus.html">Contact Us</a></li> <li><a href="career.html">Career</a></li> <li><a href="#">Lauching Soon &#187;</a> <ul> <li><a href="http://confidential/minisite.html" target="_blank" class="parent">The Vale</a></li> <li><a href="http://confidential" target="_blank" class="parent">Paragon</a></li> <li><a href="http://confidential" target="_blank" class="parent">Solstice</a></li> </ul> </li> <li><a href="investorrelations.html">Investor Relations </a> </li> <li><a href="about_us.html">About Us</a></li> </ul> </span> <div id="logo"><a href="index.html"><img src="images/logo.png" alt="confidential" border="0" height="69" width="99" /></a></div> <div id="bottom_menu10"> <div id="image_button"> </div> <div id="image_click"> </div> <div id="menu4"> <div id="body4_box1"> <div class="font_menu2" id="body4_titile1"><span class="font_menu">confidential BIZ PARK</span></div> <div class="font_menu2" id="body4_titile2"><span class="font_menu"></span></div> <div class="font_menu2" id="body4_titile3"></div> <div class="font_menu2" id="body4_titile4"></div> </div> <span class="class2"> <div id="body4_box2"> <span class="class2"> <div id="body_center1"><strong><span class="font_menu2">LOCATION</span></strong><span class="class2"> <p><a href="images/sutera-location.jpg" rel="lightbox"><img src="images/locations1.jpg" border="0" height="119" width="145" /></a><br /> <a href="map/suteradamansara.pdf" target="_blank">download to print</a> </p> </span> <p class="class2"><a href="mainsite.html"><strong class="font_vios">back to main projects</strong></a></p> </div> </span> <div class="font_menu2" id="body_center6"> <div id="table_box1"> <p class="font_menu2"><strong>FLOOR PLAN</strong></p> <p><a href="Download/floor_ria3.pdf" target="_blank">RIA 3</a><br /> <a href="Download/semi-D%20floria%20floorplan.pdf" target="_blank">FLORIA</a><br /> <a href="Download/semi-D%20gloria%20floorplan.pdf" target="_blank">GLORIA</a><br /> <a href="Download/zaria-floor-plan.pdf" target="_blank">ZARIA</a><br /> <a href="Download/SQ_floor_plan.pdf" target="_blank">SUTERA SQUARE</a><br /> </p> </div> <div id="table_box1"> <p class="font_menu2"><strong>BROCHURE</strong></p> <p><a href="Download/gravitas.pdf" target="_blank">confidential BIZ PARK</a><br /> </p> </div> <div id="table_box1"> <p class="font_menu2"><strong>UNIT TYPE</strong></p> <div class="font_menu3"> •CORPORATE FACTORY <br /> •3 STOREY LINK <br /> •SEMI DETACHED </div> <p> </p> </div> </div> <br /> <div class="font_menu2" id="body_center9"><span class="font_menu4">ALL IN-ONE CONVENIENCE</span></div> <br /> <div class="font_menu2"> •Showroom on site <br /> •Dedicated factory <br /> •Ample warehousing <br /> •Upscale office </div> <div class="font_menu2" id="body_center4">Evolve your business with the reinvention of common traditional factory space. confidential Biz Park brings factory, warehouse, office and showroom together in one functional concept. Your production and sales can now be at a single corporate address to bring efficiency and connectivity to the next level.</div> <div class="font_menu2"><span class="font_menu4">CUSTOMIZED FLEXIBILITY</span></div> <br /> <div class="font_menu2"> •Practical & Impressive infrastructure <br /> •Flexibility to customize<br /> according to needs <br /> •High Ceiling Storage Space <br /> •Generous access ways <br /> •Ample power supply </div> <div class="font_menu2" id="body_center11">Flexibility of layout that brings unprecedented customization to your business requirements.<br/></div> </div> <div id="body4_box3"> <div id="body_footer4"></div> </div> </span></div> </div> <div id="copyright"><span class="font_menu1"><strong>ALL RIGHT RESERVED 2012 &copy</strong><strong> confidential</strong><strong></strong></span></div> </div> </body></html> css code @charset "UTF-8"; ._menu { margin: 0px; padding: 0px; } #body { height: 970px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/pangeatop.jpg); background-repeat: no-repeat; background-position: center top; } #body2 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/aboutus_banner1.jpg); background-repeat: no-repeat; background-position: center top; } #body3 { height: 950px; width: 1099px; margin-right: auto; margin-left: auto; } #body4 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/finalcorner.jpg); background-repeat: no-repeat; background-position: center top; } #bodyliving { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/living2.jpg); background-repeat: no-repeat; background-position: center top; } #bodyvale { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/Finalterrace2.jpg); background-repeat: no-repeat; background-position: center top; } #bodyzaria { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/zaria.jpg); background-repeat: no-repeat; background-position: center top; } #bodyentrance { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/entrance.jpg); background-repeat: no-repeat; background-position: center top; } #body5 { height: 1200px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/contactus_banner.jpg); background-repeat: no-repeat; background-position: center top; } #address_1 { float: left; height: 150px; width: 200px; padding: 10px; } #body6 { height: 1500px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/investorrelations.jpg); background-repeat: no-repeat; background-position: center top; } #body7 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/bedroom2.jpg); background-repeat: no-repeat; background-position: center top; } #body8 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/gym.jpg); background-repeat: no-repeat; background-position: center top; } #body9 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/livinghall.jpg); background-repeat: no-repeat; background-position: center top; } #body10 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/nightview.jpg); background-repeat: no-repeat; background-position: center top; } #body11 { height: 900px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/career.jpg); background-repeat: no-repeat; background-position: center top; } #body12 { height: 1350px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/contactus_banner.jpg); background-repeat: no-repeat; background-position: center top; } #body13 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/pic5.jpg); background-repeat: no-repeat; background-position: center top; } #body14 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/pic4.jpg); background-repeat: no-repeat; background-position: center top; } #body_bangi_lakehill { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/bangi_lakehill/bangi_lakehill.jpg); background-repeat: no-repeat; background-position: center top; } #body15 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/pic3.jpg); background-repeat: no-repeat; background-position: center top; } #body16 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/bangi_lakevilla.jpg); background-repeat: no-repeat; background-position: center top; } #body17 { height: 1000px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/investorrelations.jpg); background-repeat: no-repeat; background-position: center top; } #body18 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/Mont_Jade.jpg); background-repeat: no-repeat; background-position: center top; } #body19 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban1.jpg); background-repeat: no-repeat; background-position: center top; } #body20 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/atria_1.jpg); background-repeat: no-repeat; background-position: center top; } #body21 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/atria_2.jpg); background-repeat: no-repeat; background-position: center top; } #body22 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/atria_3.jpg); background-repeat: no-repeat; background-position: center top; } #body23 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/atria_4.jpg); background-repeat: no-repeat; background-position: center top; } #body24 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/sribanyan.jpg); background-repeat: no-repeat; background-position: center top; } #body25 { height: 1500px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/investorrelations.jpg); background-repeat: no-repeat; background-position: center top; } #body26 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/bandarputerijaya.jpg); background-repeat: no-repeat; background-position: center top; } #body27 { height: 1350px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/investorrelations.jpg); background-repeat: no-repeat; background-position: center top; } #body28 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior1.jpg); background-repeat: no-repeat; background-position: center top; } #body29 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior2.jpg); background-repeat: no-repeat; background-position: center top; } #body30 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior3.jpg); background-repeat: no-repeat; background-position: center top; } #body31 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior4.jpg); background-repeat: no-repeat; background-position: center top; } #body32 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior5.jpg); background-repeat: no-repeat; background-position: center top; } #body33 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/sutera_damansara_image_1.jpg); background-repeat: no-repeat; background-position: center top; } #body34 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/sutera_damansara_image_2.jpg); background-repeat: no-repeat; background-position: center top; } #body35 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/sutera_damansara_image_3.jpg); background-repeat: no-repeat; background-position: center top; } #body36 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../sri_banyan/sri_banyan6.jpg); background-repeat: no-repeat; background-position: center top; } #body37 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../sri_banyan/sri_banyan2.jpg); background-repeat: no-repeat; background-position: center top; } #body38 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../sri_banyan/sri_banyan3.jpg); background-repeat: no-repeat; background-position: center top; } #body39 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../sri_banyan/sri_banyan4.jpg); background-repeat: no-repeat; background-position: center top; } #body40 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../sri_banyan/sri_banyan5.jpg); background-repeat: no-repeat; background-position: center top; } #body41 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../sri_banyan/sri_banyan1.jpg); background-repeat: no-repeat; background-position: center top; } #body42 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/body42.jpg); background-repeat: no-repeat; background-position: center top; } #body43 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/floria_room.jpg); background-repeat: no-repeat; background-position: center top; } #body44 { height: 900px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/news_room.jpg); background-repeat: no-repeat; background-position: center top; } #body45 { height: 1000px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/aboutus_banner1.jpg); background-repeat: no-repeat; background-position: center top; } #body46 { height: 900px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/news_room.jpg); background-repeat: no-repeat; background-position: center top; } #body47 { height: 1150px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/career.jpg); background-repeat: no-repeat; background-position: center top; } #body48 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban1.jpg); background-repeat: no-repeat; background-position: center top; } #body_project_pangaea { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/pangaea/pangea3.jpg); background-repeat: no-repeat; background-position: center top; } #body_project_atria_damansara { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/atria_damansara/atria_damansara.jpg); background-repeat: no-repeat; background-position: center top; } #body49 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban2.jpg); background-repeat: no-repeat; background-position: center top; } #body50 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban3.jpg); background-repeat: no-repeat; background-position: center top; } #body51 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban4.jpg); background-repeat: no-repeat; background-position: center top; } #body52 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban5.jpg); background-repeat: no-repeat; background-position: center top; } #body53 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban6.jpg); background-repeat: no-repeat; background-position: center top; } #body52 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../seremban/seremban5.jpg); background-repeat: no-repeat; background-position: center top; } #body54 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../BPJ/BPJ3.jpg); background-repeat: no-repeat; background-position: center top; } #body55 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../BPJ/BPJ2.jpg); background-repeat: no-repeat; background-position: center top; } #body56 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/body56.jpg); background-repeat: no-repeat; background-position: center top; } #body57 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/NEW_MJ1.jpg); background-repeat: no-repeat; background-position: center top; } #body58 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/body58background.jpg); background-repeat: no-repeat; background-position: center top; } #body59 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/suteramain.jpg); background-repeat: no-repeat; background-position: center top; } #body60 { height: 1130px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/gravitasmain.jpg); background-repeat: no-repeat; background-position: center top; } #body111 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont_jade_12.jpg); background-repeat: no-repeat; background-position: center top; } #body112 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/cyberjaya.jpg); background-repeat: no-repeat; background-position: center top; } #body113 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mirage_residence/mirage_residence.jpg); background-repeat: no-repeat; background-position: center top; } #body114 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior6.jpg); background-repeat: no-repeat; background-position: center top; } #body115 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/mont-jade-interior7.jpg); background-repeat: no-repeat; background-position: center top; } #body116 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/gtype.jpg); background-repeat: no-repeat; background-position: center top; } #body117 { height: 1100px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/news_room.jpg); background-repeat: no-repeat; background-position: center top; } #body118 { height: 950px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/bedroom.jpg); background-repeat: no-repeat; background-position: center top; } #body119 { height: 1000px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/aboutus_banner1.jpg); background-repeat: no-repeat; background-position: center top; } #body1200 { height: 980px; width: 1100px; margin-right: auto; margin-left: auto; background-image: url(../images/cyberjaya.jpg); background-repeat: no-repeat; background-position: center top; } #button { float: right; height: 45px; width: 185px; padding-top: 25px; background-image: url(../images/button.png); background-repeat: no-repeat; background-position: center center; padding-left: 15px; } #logo { float: left; height: 80px; width: 289px; padding-top: 10px; padding-left: 10px; } #logo2 { float: right; height: 129px; width: 130px; padding-left: 10px; } #logo3 { float: right; height: 329px; width: 170px; padding-left: 10px; } #bottom_menu { height: 230px; width: 1100px; padding-top: 630px; } #bottom_menu1 { height: 506px; width: 1100px; padding-top: 394px; } #bottom_menu2 { height: 270px; width: 1100px; padding-top: 630px; } #bottom_menu3 { height: 330px; width: 1100px; padding-top: 570px; } #bottom_menu4 { height: 806px; width: 1100px; padding-top: 394px; } #bottom_menu5 { height: 606px; width: 1100px; padding-top: 394px; } #bottom_menu6 { height: 1106px; width: 1100px; padding-top: 394px; } #bottom_menu7 { height: 956px; width: 1100px; padding-top: 394px; } #bottom_menu8 { height: 900px; width: 1100px; padding-top: 394px; } #bottom_menu9 { height: 706px; width: 1100px; padding-top: 394px; } #bottom_menu10 { height: 270px; width: 1100px; padding-top: 665px; } #menu { background-image: url(../images/body_background.png); background-repeat: repeat; height: 260px; width: 1060px; padding-top: 5px; padding-right: 20px; padding-bottom: 5px; padding-left: 20px; } #menu1 { background-image: url(../images/body_background.png); background-repeat: repeat; height: 280px; width: 1060px; padding-top: 5px; padding-right: 20px; padding-bottom: 5px; padding-left: 20px; } #menu2 { background-image: url(../images/body_background.png); background-repeat: repeat; height: 260px; width: 1060px; padding-top: 5px; padding-right: 20px; padding-bottom: 5px; padding-left: 20px; } #menu3 { background-image: url(../images/body_background.png); background-repeat: repeat; height: 260px; width: 1060px; padding-top: 5px; padding-right: 20px; padding-bottom: 5px; padding-left: 20px; } #menu4 { background-image: url(../images/body_background.png); background-repeat: repeat; height: 335px; width: 1060px; padding-top: 5px; padding-right: 20px; padding-bottom: 5px; padding-left: 20px; } #menu_box { float: right; height: 260px; width: 338px; } #menu_box1 { font-family: Arial, Helvetica, sans-serif; float: left; height: 260px; width: 160px; padding-right: 10px; padding-left: 10px; font-size: 12px; } #body_2 { height: 350px; width: 900px; margin-right: auto; margin-left: auto; padding-left: 100px; } #body_3 { height: 350px; width: 1000px; margin-right: auto; margin-left: auto; padding-left: 50px; } #body_4 { height: 850px; width: 1000px; margin-right: auto; margin-left: auto; padding-left: 50px; } #body_5 { height: 450px; width: 1000px; margin-right: auto; margin-left: auto; } #body_6 { height: 950px; width: 1000px; margin-right: auto; margin-left: auto; } #body_7 { height: 350px; width: 950px; margin-right: auto; margin-left: auto; padding-left: 50px; } #body_8 { height: 30px; width: 750px; margin-right: auto; margin-left: auto; padding-left: 150px; padding-top: 60px; padding-bottom: 120px; padding-right: 150px; } #body_9 { height: 650px; width: 950px; margin-right: auto; margin-left: auto; padding-left: 50px; } #a_box1 { float: right; height: 250px; width: 250px; padding-right: 25px; padding-left: 25px; padding-top: 50px; padding-bottom: 50px; } #a_box2 { float: right; height: 280px; width: 250px; padding-right: 25px; padding-left: 25px; padding-top: 5px; padding-bottom: 50px; } #a_box3 { float: right; height: 280px; width: 400px; padding-right: 25px; padding-left: 25px; padding-top: 5px; padding-bottom: 50px; } #title1 { height: 15px; width: 1000px; margin-right: auto; margin-left: auto; padding-top: 8px; } #title2 { height: 30px; width: 1000px; margin-right: auto; margin-left: auto; } #image31 { height: 115px; width: 1000px; margin-right: auto; margin-left: auto; } #image32 { height: 90px; width: 1000px; margin-right: auto; margin-left: auto; } #title2_box1 { float: right; height: 20px; width: 110px; padding-top: 10px; } #image31_1 { float: right; height: 100px; width: 110px; padding-top: 10px; } #image_32a { float: left; height: 90px; width: 240px; } #image_32b { float: right; height: 90px; width: 110px; padding-left: 90px; } #image_32c { float: right; height: 90px; width: 180px; } #image_32d { float: right; height: 90px; width: 140px; padding-right: 10px; padding-left: 10px; } #image_32e { float: right; height: 90px; width: 170px; padding-right: 10px; } #image31_2 { float: right; height: 100px; width: 610px; padding-top: 10px; } #image31_3 { float: left; height: 100px; width: 240px; padding-top: 10px; } #right_main { float: left; height: 30px; width: 108px; text-align: left; } #right_main2 { float: left; height: 25px; width: 207px; text-align: center; } #right_main3 { float: left; height: 22px; width: 107px; text-align: left; padding-top: 0px; } #right_main4 { float: left; height: 30px; width: 105px; text-align: left; } #right_main5 { float: left; height: 30px; width: 110px; text-align: left; } #title2_box2 { float: right; height: 20px; width: 610px; padding-top: 10px; } #title2_box3 { float: left; height: 20px; width: 160px; padding-top: 10px; } #body4_box1 { height: 30px; width: 1000px; margin-right: auto; margin-left: auto; } #body4_box2 { height: 215px; width: 1000px; margin-right: auto; margin-left: auto; } #body4_titile1 { float: left; height: 20px; width: 350px; padding-top: 10px; } #body4_titile2 { float: right; height: 20px; width: 180px; padding-top: 10px; padding-left: 20px; } #body4_titile3 { float: right; height: 20px; width: 160px; padding-top: 10px; } #body4_titile4 { float: right; height: 20px; width: 240px; padding-top: 10px; } #body4_titile5 { float: right; height: 20px; width: 200px; padding-top: 10px; } #body4_titile6 { float: left; height: 20px; width: 350px; padding-top: 10px; } #body_center1 { float: right; height: 200px; width: 180px; margin-left: 20px; margin-top: 17px; text-align: left; } #body_footer4 { float: left; height: 20px; width: 200px; text-align: right; } #image_click { height: 60px; width: 1000px; margin-left: auto; } #body4_box3 { height: 20px; width: 1000px; margin-right: auto; margin-left: auto; } #body_center2 { float: right; height: 215px; width: 160px; margin-left: 30px; margin-top: 20px; } #body_center3 { float: right; height: 190px; width: 160px; } #body_center4 { float: left; height: 200px; width: 150px; margin-right: 50px; margin-top: 15px; } #body_center5 { float: left; height: 200px; width: 150px; margin-top: 15px; } #body_center6 { float: right; height: 190px; width: 450px; } #body_center7 { float: left; height: 200px; width: 450px; margin-right: 50px; margin-top: 15px; } #body_center8 { float: left; height: 200px; width: 150px; margin-right: 50px; margin-top: 15px; } #body_center10 { float: left; height: 200px; width: 750px; margin-right: 50px; margin-top: 15px; } #body_center11 { float: left; height: 60px; width: 150px; margin-top: 15px; } #image_clicka { float: right; height: 42px; width: 71px; margin-right: 20px; margin-top: 10px; } .font_9 { font-family: Arial, Helvetica, sans-serif; font-size: 11px; color: #B59859; } #copyright { font-family: Arial, Helvetica, sans-serif; font-size: 9px; height: 30px; width: 1100px; text-align: right; float: right; } #main_site { float: right; height: 10px; width: 100px; margin-top: 25px; } .back_main { font-family: Arial, Helvetica, sans-serif; font-size: 10px; color: #B59859; } #aboutus { float: left; height: 50px; width: 180px; } #vision { float: left; height: 50px; width: 380px; } #contactus { float: left; height: 50px; width: 250px; } #investor { float: left; height: 50px; width: 350px; }#contact_box1 { float: left; height: 800px; width: 450px; border-right-width: 1px; border-right-style: dotted; padding-right: 30px; margin-top: 30px; margin-bottom: 30px; } .FONT_MAP { font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #F5F5F5; } #contact_box { float: right; height: 800px; width: 450px; padding-top: 40px; padding-right: 20px; padding-bottom: 10px; padding-left: 10px; } #contact_left { float: left; height: 800px; width: 450px; } #contact_box3 { float: left; padding-top: 10px; padding-right: 10px; padding-bottom: 10px; padding-left: 10px; height: 150px; width: 200px; } #contact_box4 { float: left; padding-right: 10px; padding-bottom: 10px; padding-left: 10px; height: 150px; width: 200px; } #MENU_BOX_RIGHT { float: right; height: 190px; width: 165px; } .font_vios { font-family: Arial, Helvetica, sans-serif; font-size: 11px; } #financial { float: left; height: 500px; width: 200px; padding-left: 200px; } #financial2 { float: left; height: 500px; width: 360px; padding-left: 140px; } #table_box3 { padding: 5px; height: 170px; width: 163px; float: right; } #table_box1 { padding: 5px; height: 170px; width: 123px; float: right; } #table_box2 { padding: 5px; height: 170px; width: 383px; float: right; } #table_box { height: 330px; width: 940px; padding: 30px; } #table_box12 { padding top: 5px; padding-left: 5px; height: 190px; width: 180px; float: right; } #table_box13 { padding: 5px; height: 170px; width: 103px; float: right; } #table_box14 { padding: 5px; height: 170px; width: 140px; float: right; } #investor_form { height: 700px; width: 600px; float: right; padding-top: 50px; } #b_ins { float: left; width: 280px; height: 600px; padding-top: 50px; padding-right: 10px; } #financial3 { float: left; height: 500px; width: 400px; } #financial4 { float: left; height: 500px; width: 450px; } #newsroom { height: 375px; width: 930px; overflow: scroll; } #career_page { height: 300px; width: 700px; } #company_annoucement { float: left; height: 200px; width: 220px; padding-right: 20px; padding-left: 80px; padding-top: 50px; } #company_annoucement2 { float: left; height: 200px; width: 300px; padding-right: 20px; padding-left: 30px; padding-top: 50px; } #vision { float: left; height: 50px; width: 800px; } #annoucement_box { height: 100px; width: 200px; text-align: center; vertical-align: middle; padding-top: 80px; } .red { font-size: 9px; color: #FFF; font-family: "Arial Black", Gadget, sans-serif; } .FONT_11MAP { font-size: 11px; color: #B59859; } #new_table { height: 150px; width: 100px; } .red { color: #F00; } #financial5 { float: left; height: 500px; width: 400px; } #body4_titile122 { float: left; height: 20px; width: 400px; padding-top: 10px; }
  6. okay so i have this problem i dont know how to fix it.. my 1st query runs well..but the 2nd query doesnt work.. on the 2nd query for year 2009..the answer should be 61.28 while the other 100.. it shows the same answer as year 2001.. how do i fix this.. <?php require("html2fpdf.php"); $server = 'localhost'; $username = ''; $password = ''; $database_name=''; $dbconn = mysql_connect($server, $username,$password,false) or die("Could not establish connection"); mysql_select_db($database_name, $dbconn) or die ("Could not select database"); if (!$dbconn) { die('Something went wrong while connecting to MSSQL'); } ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title></title> <h5 align="center"><U>KRETAM HOLDINGS BERHAD (168285-H)</U></h5> <h4 align="left">List-Field</h4> </head> <body> <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> </tr> <tr> <th style="font-style: italic;">Field No</th> <th style="font-style: italic;">Ex Field No</th> <th style="font-style: italic;">Planting Year</th> <th style="font-style: italic;">Land Utilities</th> <th style="font-style: italic;">Field Hectares</th> <th style="font-style: italic;">Annual Total</th> <th style="font-style: italic;">Total Hectares</th> <br /> </tr> <tr> <th>Mature</th> <br /> </tr> <? $query="SELECT tblfield.*, annualtotal,annualrowcount FROM tblfield left join vwfield_annualtotal_location on vwfield_annualtotal_location.locationid = tblfield.locationid and vwfield_annualtotal_location.type = tblfield.type and vwfield_annualtotal_location.plantingyear = tblfield.plantingyear WHERE tblfield.type='mature' ORDER BY tblfield.statementyear, tblfield.type desc, tblfield.plantingyear"; $result=mysql_query($query); $grandtotalhec=0; $i = 1; while($row=mysql_fetch_array($result)) { echo $_POST["selection"]; $fieldno = $row['fieldno']; $exfieldno = $row['exfieldno']; $plantingyear = $row['plantingyear']; $statementyear = $row['statementyear']; $fieldhectares = $row['fieldhectares']; $annualrowcount = $row['annualrowcount']; if ($i==$annualrowcount) { $annualtotal = $row['annualtotal']; $i =1; } else { $annualtotal = ''; $i =$i + 1; } end; $totalhectares = $row['totalhectares']; echo "<tr><td align='center'>$fieldno</td>"; echo "<td align='center'>$exfieldno</td></tr>"; echo "<td align='center'>$plantingyear</td></tr>"; echo "<td align='center'></td></tr>"; echo "<td align='center'>$fieldhectares</td></tr>"; echo "<td align='center'>$annualtotal</td></tr>"; //$query="SELECT plantingyear, locationid, SUM(fieldhectares) AS annualtotal //FROM tblfield WHERE type='mature' AND locationid='4' AND plantingyear='$plantingyear' GROUP BY locationid, plantingyear"; // $result=mysql_query($query); //while($row=mysql_fetch_array($result)) { //$totalhectares = $row['annualtotal']; echo "<td align='center'>$totalhectares</td></tr>"; $grandtotalhec = $grandtotalhec + $fieldhectares; }echo "<tr>"; echo "<th>Immature</th>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td align='center'>".$grandtotalhec."</td>"; echo "</tr>"; $query="SELECT tblfield.*, annualtotal,annualrowcount FROM tblfield left join vwfield_annualtotal_location on vwfield_annualtotal_location.locationid = tblfield.locationid and vwfield_annualtotal_location.type = tblfield.type and vwfield_annualtotal_location.plantingyear = tblfield.plantingyear WHERE tblfield.type='immature' ORDER BY tblfield.statementyear, tblfield.type desc, tblfield.plantingyear"; $result=mysql_query($query); $grandtotalhec2=0; $i = 1; while($row=mysql_fetch_array($result)) { echo $_POST["selection"]; $fieldno = $row['fieldno']; $exfieldno = $row['exfieldno']; $type = $row['type']; $plantingyear = $row['plantingyear']; $statementyear = $row['statementyear']; $fieldhectares = $row['fieldhectares']; $totalhectares = $row['totalhectares']; echo "<tr><td align='center'>$fieldno</td>"; echo "<td align='center'>$exfieldno</td></tr>"; echo "<td align='center'>$plantingyear</td></tr>"; echo "<td align='center'></td></tr>"; echo "<td align='center'>$fieldhectares</td></tr>"; echo "<td align='center'>$annualtotal</td></tr>"; echo "<td align='center'>$totalhectares</td></tr>"; $grandtotalhec2 = $grandtotalhec2 + $fieldhectares; } echo "<tr>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td align='center'>$grandtotalhec2</td>"; echo "</tr>"; $query="SELECT * FROM tblfield ORDER BY statementyear, type desc, plantingyear"; $result=mysql_query($query); $grandtotalhec3=0; while($row=mysql_fetch_array($result)) { echo $_POST["selection"]; $fieldhectares = $row['fieldhectares']; $grandtotalhec3 = $grandtotalhec3 + $fieldhectares; } echo "<tr>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td align='center'>Grandtotal</td>"; echo "<td align='center'>$grandtotalhec3</td>"; echo "</tr>"; ?> </tbody> </table><h4 align="left">List-Land Utilities</h4> <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> </tbody> <tr> </tr> <tr> <th align="left" style="font-style: italic;">Description</th> <th style="font-style: italic;">Statement Year</th> <th style="font-style: italic;">Land Hectares</th> <th style="font-style: italic;">Total Hectares</th> </tr> <? $query="SELECT * FROM tbllandutilities"; $result=mysql_query($query); $grandtotallandhec4=0; while($row=mysql_fetch_array($result)) { $description = $row['description']; $statementyear = $row['statementyear']; $landhectares = $row['landhectares']; $totalhectares = $row['totalhectares']; echo "<tr><td>$description</td>"; echo "<td align='center'>$statementyear</td></tr>"; echo "<td align='center'>$landhectares</td></tr>"; echo "<td>$totalhectares</td></tr>"; $grandtotalhec4 = $grandtotalhec4 + $landhectares; } echo "<tr>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td align='center'>$grandtotalhec4</td>"; echo "</tr>"; ?> </tbody> </table> <br> </body> </html> <?php $var = ob_get_clean(); $pdf = new HTML2FPDF('P', 'mm', 'Letter'); $pdf->AddPage(); $pdf->WriteHTML($var); $pdf->Output('test.pdf', 'I'); ?>
  7. i want the TYPE to appear like the ones i edit with red font..
  8. oh yes..1 more thing..it will also show by type in order by mature 1st then immature..like in the photo..any php guru pls help me..
  9. im new..so i need your help. hard for me to explain so i just attached a photo how I need it to be.. this is the view <div class="view"> <?php $con = mysql_connect("","root",""); mysql_select_db('', $con); $this->beginWidget('zii.widgets.jui.CJuiDialog', array( 'id'=>$data->id, // additional javascript options for the dialog plugin 'options'=>array( 'title'=>'Report (Other)', 'autoOpen'=>false, 'modal'=>true, 'resizable' =>false, ), )); echo "<form action=\"report/$data->name.php\" name=\"selection\" method=\"post\" target=\"_blank\">"; echo "<b><font style=\"font-size:12px; \">$data->name <br><br>"; if (($data->haslocation) == 1) { $sql="SELECT * FROM tbllocation"; $result = mysql_query($sql,$con); echo "Location : "; echo "<select name=location value=''>location</option>"; echo "<option value=0></option>"; while ($row=mysql_fetch_array($result)) { $id=$row["id"]; $code=$row["code"]; $description=$row["description"]; echo "<option value=$id>$description </option>"; } echo "</select>"; echo "<br><br>"; } if (($data->hasdistrict) == 1) { $sql="SELECT * FROM tbldistrict"; $result = mysql_query($sql,$con); echo "District : "; echo "<select name=\"district\" >district</option>"; echo "<option value=0></option>"; while ($row=mysql_fetch_array($result)) { $id=$row["id"]; $code=$row["code"]; $description=$row["description"]; echo "<option value=$id>$description </option>"; } echo "</select>"; echo "</font><br><br>"; } echo "<input type=\"submit\" value=\"Preview\" style=\"font-size:12px;font-family:verdana; \"/>"; echo "</form>"; $this->endWidget('zii.widgets.jui.CJuiDialog'); // the link that may open the dialog //<img src="themes\shadow_dancer\images\small_icons\preview.png" width="4%"></img> echo CHtml::link('', '#', array( 'onclick'=>'$("#'.$data->id.'").dialog("open"); return false;', )); ?> <?php echo CHtml::link($data->name, '#', array( 'onclick'=>'$("#'.$data->id.'").dialog("open"); return false;', )); ?> </div> and this is the report page <?php require("html2fpdf.php"); $server = ''; $username = ''; $password = ''; $database_name=''; $dbconn = mysql_connect($server, $username,$password,false) or die("Could not establish connection"); mysql_select_db($database_name, $dbconn) or die ("Could not select database"); if (!$dbconn) { die('Something went wrong while connecting to MSSQL'); } ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title></title> <h5 align="center"><U>KRETAM HOLDINGS BERHAD (168285-H)</U></h5> </head> <body> <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <th align="left" colspan="2" rowspan="1" style="font-style: italic;">List-Field</th> </tr> <tr> <th style="font-style: italic;">Field No</th> <th style="font-style: italic;">Ex Field No</th> <th style="font-style: italic;">Type</th> <th style="font-style: italic;">Planting Year</th> <th style="font-style: italic;">Statement Year</th> <th style="font-style: italic;">Field Hectares</th> <th style="font-style: italic;">Total Hectares</th> <br /> </tr> <? $query="SELECT * FROM tblfield ORDER BY statementyear, type desc, plantingyear"; $result=mysql_query($query); $grandtotalhec=0; while($row=mysql_fetch_array($result)) { echo $_POST["selection"]; $fieldno = $row['fieldno']; $exfieldno = $row['exfieldno']; $type = $row['type']; $plantingyear = $row['plantingyear']; $statementyear = $row['statementyear']; $fieldhectares = $row['fieldhectares']; $totalhectares = $row['totalhectares']; echo "<tr><td align='center'>$fieldno</td>"; echo "<td align='center'>$exfieldno</td></tr>"; echo "<td align='center'>$type</td></tr>"; echo "<td align='center'>$plantingyear</td></tr>"; echo "<td align='center'>$statementyear</td></tr>"; echo "<td align='center'>$fieldhectares</td></tr>"; echo "<td align='center'>$totalhectares</td></tr>"; $grandtotalhec = $grandtotalhec + $fieldhectares; } echo "<tr>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td></td>"; echo "<td align='center' colspan=9>".$grandtotalhec."</td>"; echo "</tr>"; ?> </tbody> </table> <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> </tbody> <tr> <th align="left" colspan="1" rowspan="1" style="font-style: italic;">List-Land Utilities</th> </tr> <tr> <th align="left" style="font-style: italic;">Description</th> <th style="font-style: italic;">Location ID</th> <th style="font-style: italic;">Statement Year</th> <th style="font-style: italic;">Land Hectares</th> <th style="font-style: italic;">Total Hectares</th> </tr> <? $query="SELECT * FROM tbllandutilities"; $result=mysql_query($query); $grandtotallandhec=0; while($row=mysql_fetch_array($result)) { $description = $row['description']; $locationid = $row['locationid']; $statementyear = $row['statementyear']; $landhectares = $row['landhectares']; $totalhectares = $row['totalhectares']; echo "<tr><td>$description</td>"; echo "<td align='center'>$locationid</td></tr>"; echo "<td align='center'>$statementyear</td></tr>"; echo "<td align='center'>$landhectares</td></tr>"; echo "<td>$totalhectares</td></tr>"; } ?> </tbody> </table> <br> </body> </html> <?php $var = ob_get_clean(); $pdf = new HTML2FPDF('P', 'mm', 'Letter'); $pdf->AddPage(); $pdf->WriteHTML($var); $pdf->Output('test.pdf', 'I'); ?> so basically i need it to show in order by the statementyear.. another statementyear, another page.. perhaps anyone can show me how to amend my codes.
  10. i dont know how to combine the alias to the current query.can u perhaps help me alter mine.
  11. I have these two tables. One of it is (tbllocation) and the other (tbldistrict). So i need to display the datas but the problem is both of the column names that i wanna display have same column names which is (description).i dont know how to do it.if i use both (description), it will only show the data from (tbllocation). so here are my codes <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td colspan="2" rowspan="1" style="font-style: italic;">List-Location</td> </tr> <tr> <td style="font-style: italic;">code</td> <td style="font-style: italic;">description</td> <td style="font-style: italic;">districtid</td> </tr> <? $query="SELECT * FROM tbllocation LEFT JOIN tbldistrict ON tbllocation.districtid = tbldistrict.id"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { $code = $row['code']; $description = $row['description']; $districtid = $row['districtid']; echo "<tr><td>$code</td>"; echo "<td>$description</td></tr>"; echo "<td>$districtid</td></tr>"; } ?> </tbody> </table> and the photo explains from what it is now(photo 1)..and how do i want it to be..(photo 2)
  12. im an amateur..please show me how to do this this is my code <?php require("html2fpdf.php"); $server = ''; $username = ''; $password = ''; $database_name=''; $dbconn = mysql_connect($server, $username,$password,false) or die("Could not establish connection"); mysql_select_db($database_name, $dbconn) or die ("Could not select database"); if (!$dbconn) { die('Something went wrong while connecting to MSSQL'); } ob_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title></title> <h5 align="center"><U>confidential</U></h5> </head> <body> <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td colspan="2" rowspan="1" style="font-style: italic;">List-Field</td> </tr> <tr> <td style="font-style: italic;">Field No</td> <td style="font-style: italic;">Ex Field No</td> <td style="font-style: italic;">Type</td> <td style="font-style: italic;">Planting Year</td> <td style="font-style: italic;">Field Hectares</td> <td style="font-style: italic;">Reference</td> <td style="font-style: italic;">Location ID</td> <td style="font-style: italic;">Statement Year</td> <td style="font-style: italic;">Total Hectares</td> <br /> </tr> <? $query="SELECT * FROM tblfield"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { $fieldno = $row['fieldno']; $exfieldno = $row['exfieldno']; $type = $row['type']; $plantingyear = $row['plantingyear']; $fieldhectares = $row['fieldhectares']; $reference = $row['reference']; $locationid = $row['locationid']; $statementyear = $row['statementyear']; $totalhectares = $row['totalhectares']; echo "<tr><td>$fieldno</td>"; echo "<td>$exffieldno</td></tr>"; echo "<td>$type</td></tr>"; echo "<td>$plantingyear</td></tr>"; echo "<td>$fieldhectares</td></tr>"; echo "<td>$reference</td></tr>"; echo "<td>$locationid</td></tr>"; echo "<td>$statementyear</td></tr>"; echo "<td>$totalhectares</td></tr>"; } ?> </tbody> </table> <table style="text-align: left; width: 715px; height: 32px;" border="1" cellpadding="2" cellspacing="2"> </tbody> <tr> <td colspan="2" rowspan="1" style="font-style: italic;">List-Land Utilities</td> </tr> <tr> <td style="font-style: italic;">Description</td> <td style="font-style: italic;">Land Hectares</td> <td style="font-style: italic;">Statement Year</td> <td style="font-style: italic;">Location ID</td> <td style="font-style: italic;">Total Hectares</td> </tr> <? $query="SELECT * FROM tbllandutilities"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { $description = $row['description']; $landhectares = $row['landhectares']; $statementyear = $row['statementyear']; $locationid = $row['locationid']; $totalhectares = $row['totalhectares']; echo "<tr><td>$description</td>"; echo "<td>$landhectares</td></tr>"; echo "<td>$statementyear</td></tr>"; echo "<td>$locationid</td></tr>"; echo "<td>$totalhectares</td></tr>"; } ?> </tbody> </table> <br> </body> </html> <?php $var = ob_get_clean(); $pdf = new HTML2FPDF('P', 'mm', 'Letter'); $pdf->AddPage(); $pdf->WriteHTML($var); $pdf->Output('test.pdf', 'I'); ?> i need to get both the totals from these two table..then get the grandtotal.. and perhaps check my codes i know they are messed up PHOTO EXPLAINS ALL
  13. sorry <? $query="SELECT l.*, d.description AS district FROM xtbllocation AS l LEFT JOIN xtbldistrict AS d ON l.code = d.code"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { $code = $row['code']; $description = $row['description']; $districtid = $row['districtid']; echo "<tr><td>$code</td>"; echo "<td>$description</td></tr>"; echo "<td>$districtid</td></tr>"; } ?> 1 thing i didnt mention..im using YII framework
  14. yep..sure.but still..doesnt work
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.