• الإعلانات

    • فيصل الحربي

      تسجيل عضوية جديدة في المنتدى   01/31/2016

      السلام عليكم ورحمة الله وبركاته  عزيزي العضو الجديد :  حاليا رسالة الإيميل لتأكيد صحة إيميلكم تذهب للبريد العشوائي ( جاري حل المشكلة )  فإذا لم تجد رسالة التحقق من إيميلكم في صندوق الوارد لديكم إتجه للبريد العشوائي ( JUNK)  وقم بتفعيل إشتراككم من هناك   

البحث في المنتدى

Showing results for tags 'وورد بريس'.

  • البحث بالتاقات

    اكتب الكلمات المفتاحيه بينها علامه الفاصله
  • البحث بكاتب الموضوع

تم إيجاد 5 نتيجة

  1. السلام عليكم ورحمه الله وبركاته وشهر مبارك وكل عام والجميع بخير استيراد بيانات من وورد الى اكسس ممكن الافاده حول هذا الموضوع وارسال الكود او نبده من البرنامج
  2. السلام عليكم ..   يا جماعة انا ما اعرف الا القليل جدا في php وعندي مشكلة حاولت احلها بس والله ما نجحت لحد الحين وهي:   ان اتجاه الصفحة يظهر من اليمين لليسار وهذا جيد ولكن المشكلة عند تصدير الصفحة لملف وورد يتغير الاتجاه فيصبح من اليسار لليمين !! جربت واضفت dir= rtl في اكثر من مكان في بس ما نجحت يا ليت تفيدوني وين اضفيك الكود او عن حل بديل وشكرا. <?php @ini_set("display_errors","1");@ini_set("display_startup_errors","1");include("include/dbcommon.php");include("classes/searchclause.php");include("classes/sql.php");session_cache_limiter("none");include("include/employees_variables.php");if(!CheckTablePermissions($strTableName, "P")) HeaderRedirect("menu");$layout = new TLayout("export2", "MetroCity", "MobileCity");$layout->version = 2;$layout->blocks["top"] = array();$layout->containers["export"] = array();$layout->containers["export"][] = array("name"=>"exportheader", "block"=>"", "substyle"=>2 );$layout->containers["export"][] = array("name"=>"wrapper", "block"=>"", "substyle"=>1 , "container"=>"range" );$layout->containers["range"] = array();$layout->containers["range"][] = array("name"=>"exprange", "block"=>"range_block", "substyle"=>1 );$layout->skins["range"] = "fields";$layout->containers["export"][] = array("name"=>"wrapper", "block"=>"", "substyle"=>1 , "container"=>"fields" );$layout->containers["fields"] = array();$layout->containers["fields"][] = array("name"=>"expoutput", "block"=>"", "substyle"=>1 );$layout->skins["fields"] = "fields";$layout->containers["export"][] = array("name"=>"expbuttons", "block"=>"", "substyle"=>2 );$layout->skins["export"] = "1";$layout->blocks["top"][] = "export";$page_layouts["employees_export"] = $layout;$layout->skinsparams = array();$layout->skinsparams["empty"] = array("button"=>"button1");$layout->skinsparams["menu"] = array("button"=>"button1");$layout->skinsparams["hmenu"] = array("button"=>"button1");$layout->skinsparams["undermenu"] = array("button"=>"button1");$layout->skinsparams["fields"] = array("button"=>"button1");$layout->skinsparams["form"] = array("button"=>"button1");$layout->skinsparams["1"] = array("button"=>"button1");$layout->skinsparams["2"] = array("button"=>"button1");$layout->skinsparams["3"] = array("button"=>"button1");// Modify query: remove blob fields from fieldlist.// Blob fields on an export page are shown using imager.php (for example).// They don't need to be selected from DB in export.php itself.//$gQuery->ReplaceFieldsWithDummies(GetBinaryFieldsIndices());$cipherer = new RunnerCipherer($strTableName);$strWhereClause = "";$strHavingClause = "";$strSearchCriteria = "and";$selected_recs = array();$options = "1";header("Expires: Thu, 01 Jan 1970 00:00:01 GMT"); include('include/xtempl.php');include('classes/runnerpage.php');$xt = new Xtempl();$id = postvalue("id") != "" ? postvalue("id") : 1;$phpVersion = (int)substr(phpversion(), 0, 1); if($phpVersion > 4){ include("include/export_functions.php"); $xt->assign("groupExcel", true);}else $xt->assign("excel", true);//array of params for classes$params = array("pageType" => PAGE_EXPORT, "id" => $id, "tName" => $strTableName);$params["xt"] = &$xt;if(!$eventObj->exists("ListGetRowCount") && !$eventObj->exists("ListQuery")) $params["needSearchClauseObj"] = false;$pageObject = new RunnerPage($params);$pageObject->init();// Before Process eventif($eventObj->exists("BeforeProcessExport")) $eventObj->BeforeProcessExport($conn, $pageObject);if (@$_REQUEST["a"]!=""){ $options = ""; $sWhere = "1=0"; // process selection $selected_recs = array(); if (@$_REQUEST["mdelete"]) { foreach(@$_REQUEST["mdelete"] as $ind) { $keys=array(); $keys["emp_no"] = refine($_REQUEST["mdelete1"][mdeleteIndex($ind)]); $selected_recs[] = $keys; } } elseif(@$_REQUEST["selection"]) { foreach(@$_REQUEST["selection"] as $keyblock) { $arr=explode("&",refine($keyblock)); if(count($arr)<1) continue; $keys = array(); $keys["emp_no"] = urldecode($arr[0]); $selected_recs[] = $keys; } } foreach($selected_recs as $keys) { $sWhere = $sWhere . " or "; $sWhere.=KeyWhere($keys); } $strSQL = $gQuery->gSQLWhere($sWhere); $strWhereClause=$sWhere; $_SESSION[$strTableName."_SelectedSQL"] = $strSQL; $_SESSION[$strTableName."_SelectedWhere"] = $sWhere; $_SESSION[$strTableName."_SelectedRecords"] = $selected_recs;}if ($_SESSION[$strTableName."_SelectedSQL"]!="" && @$_REQUEST["records"]=="") { $strSQL = $_SESSION[$strTableName."_SelectedSQL"]; $strWhereClause = @$_SESSION[$strTableName."_SelectedWhere"]; $selected_recs = $_SESSION[$strTableName."_SelectedRecords"];}else{ $strWhereClause = @$_SESSION[$strTableName."_where"]; $strHavingClause = @$_SESSION[$strTableName."_having"]; $strSearchCriteria = @$_SESSION[$strTableName."_criteria"]; $joinFromPart = @$_SESSION[$strTableName."_joinFromPart"]; //$strSQL = $gQuery->gSQLWhere($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL = SQLQuery::gSQLWhere_having($gQuery->HeadToSql(), $gQuery->FromToSql().$joinFromPart, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); }$mypage = 1;if(@$_REQUEST["type"]){// order by $strOrderBy = $_SESSION[$strTableName."_order"]; if(!$strOrderBy) $strOrderBy = $gstrOrderBy; $strSQL.=" ".trim($strOrderBy); $strSQLbak = $strSQL; if($eventObj->exists("BeforeQueryExport")) $eventObj->BeforeQueryExport($strSQL,$strWhereClause,$strOrderBy, $pageObject);// Rebuild SQL if needed if($strSQL!=$strSQLbak) {// changed $strSQL - old style $numrows=GetRowCount($strSQL); } else { //$strSQL = $gQuery->gSQLWhere($strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL = SQLQuery::gSQLWhere_having($gQuery->HeadToSql(), $gQuery->FromToSql().$joinFromPart, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); $strSQL.=" ".trim($strOrderBy); $rowcount=false; if($eventObj->exists("ListGetRowCount")) { $masterKeysReq=array(); for($i = 0; $i < count($pageObject->detailKeysByM); $i ++) $masterKeysReq[] = $_SESSION[$strTableName."_masterkey".($i + 1)]; $rowcount = $eventObj->ListGetRowCount($pageObject->searchClauseObj,$_SESSION[$strTableName."_mastertable"],$masterKeysReq,$selected_recs, $pageObject); } if($rowcount !== false) $numrows = $rowcount; else { //$numrows = $gQuery->gSQLRowCount($strWhereClause,$strHavingClause,$strSearchCriteria); $numrows = SQLQuery::gSQLRowCount_int($gQuery->HeadToSql(), $gQuery->FromToSql().$joinFromPart, $gQuery->WhereToSql(), $gQuery->GroupByToSql(), $gQuery->Having()->toSql($gQuery), $strWhereClause, $strHavingClause, $strSearchCriteria); } } LogInfo($strSQL);// Pagination: $nPageSize = 0; if(@$_REQUEST["records"]=="page" && $numrows) { $mypage = (integer)@$_SESSION[$strTableName."_pagenumber"]; $nPageSize = (integer)@$_SESSION[$strTableName."_pagesize"]; if(!$nPageSize) $nPageSize = $gSettings->getInitialPageSize(); if($nPageSize<0) $nPageSize = 0; if($nPageSize>0) { if($numrows<=($mypage-1)*$nPageSize) $mypage = ceil($numrows/$nPageSize); if(!$mypage) $mypage = 1; $strSQL.=" limit ".(($mypage-1)*$nPageSize).",".$nPageSize; } } $listarray = null; if($eventObj->exists("ListQuery")) { $arrFieldForSort = array(); $arrHowFieldSort = array(); require_once getabspath('classes/orderclause.php'); $fieldList = unserialize($_SESSION[$strTableName."_orderFieldsList"]); for($i = 0; $i < count($fieldList); $i++) { $arrFieldForSort[] = $fieldList[$i]->fieldIndex; $arrHowFieldSort[] = $fieldList[$i]->orderDirection; } $listarray = $eventObj->ListQuery($pageObject->searchClauseObj, $arrFieldForSort, $arrHowFieldSort, $_SESSION[$strTableName."_mastertable"], $masterKeysReq, $selected_recs, $nPageSize, $mypage, $pageObject); } if($listarray != null) { $rs = $listarray; } elseif($nPageSize>0) { $rs = db_query($strSQL,$conn); } else $rs = db_query($strSQL,$conn); if(!ini_get("safe_mode")) set_time_limit(300); if(substr(@$_REQUEST["type"],0,5)=="excel") {// remove grouping $locale_info["LOCALE_SGROUPING"]="0"; $locale_info["LOCALE_SMONGROUPING"]="0"; if($phpVersion > 4) ExportToExcel($rs, $nPageSize, $eventObj, $cipherer, $pageObject); else ExportToExcel_old($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } else if(@$_REQUEST["type"]=="word") { ExportToWord($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } else if(@$_REQUEST["type"]=="xml") { ExportToXML($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } else if(@$_REQUEST["type"]=="csv") { $locale_info["LOCALE_SGROUPING"]="0"; $locale_info["LOCALE_SDECIMAL"]="."; $locale_info["LOCALE_SMONGROUPING"]="0"; $locale_info["LOCALE_SMONDECIMALSEP"]="."; ExportToCSV($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); } db_close($conn); return;}// add button events if exist$pageObject->addButtonHandlers();if($options){ $xt->assign("rangeheader_block",true); $xt->assign("range_block",true);}$xt->assign("exportlink_attrs", 'id="saveButton'.$pageObject->id.'"');$pageObject->body["begin"] .= GetBaseScriptsForPage(false);$pageObject->fillSetCntrlMaps();$pageObject->body['end'] .= '<script>';$pageObject->body['end'] .= "window.controlsMap = ".my_json_encode($pageObject->controlsHTMLMap).";";$pageObject->body['end'] .= "window.viewControlsMap = ".my_json_encode($pageObject->viewControlsHTMLMap).";";$pageObject->body['end'] .= "window.settings = ".my_json_encode($pageObject->jsSettings).";";$pageObject->body['end'] .= '</script>';$pageObject->body["end"] .= "<script language=\"JavaScript\" src=\"".GetRootPathForResources("include/runnerJS/RunnerAll.js")."\"></script>\r\n";$pageObject->addCommonJs();$pageObject->body["end"] .= "<script>".$pageObject->PrepareJS()."</script>";$xt->assignbyref("body",$pageObject->body);$pageObject->display(GetTemplateName("employees", "export"));$table["direction"] = "rtl";function ExportToExcel_old($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject){ global $cCharset; header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".xls"); echo "<html>"; echo "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">"; echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=".$cCharset."\">"; echo "<body>"; echo "<table border=1>"; WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); echo "</table>"; echo "</body>"; echo "</html>";}function ExportToWord($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject){ global $cCharset; header("Content-Type: application/vnd.ms-word"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".doc"); echo "<html>"; echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=".$cCharset."\">"; echo "<body>"; echo "<table border=1>"; WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject); echo "</table>"; echo "</body>"; echo "</html>";}function ExportToXML($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject){ global $cCharset; header("Content-Type: text/xml"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".xml"); if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs); //if(!$row) // return; echo "<?xml version=\"1.0\" encoding=\"".$cCharset."\" standalone=\"yes\"?>\r\n"; echo "<table>\r\n"; $i = 0; $pageObject->viewControls->forExport = "xml"; while((!$nPageSize || $i<$nPageSize) && $row) { $values = array(); $values["emp_no"] = $pageObject->getExportValue("emp_no", $row); $values["birth_date"] = $pageObject->getExportValue("birth_date", $row); $values["first_name"] = $pageObject->getExportValue("first_name", $row); $values["last_name"] = $pageObject->getExportValue("last_name", $row); $values["gender"] = $pageObject->getExportValue("gender", $row); $values["hire_date"] = $pageObject->getExportValue("hire_date", $row); $eventRes = true; if ($eventObj->exists('BeforeOut')) $eventRes = $eventObj->BeforeOut($row, $values, $pageObject); if ($eventRes) { $i++; echo "<row>\r\n"; foreach ($values as $fName => $val) { $field = runner_htmlspecialchars(XMLNameEncode($fName)); echo "<".$field.">"; echo $values[$fName]; echo "</".$field.">\r\n"; } echo "</row>\r\n"; } if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs); } echo "</table>\r\n";}function ExportToCSV($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject){ header("Content-Type: application/csv"); header("Content-Disposition: attachment;Filename=".GetTableURL($strTableName).".csv"); echo "\xEF\xBB\xBF"; if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs);// write header $outstr = ""; if($outstr!="") $outstr.=","; $outstr.= "\"emp_no\""; if($outstr!="") $outstr.=","; $outstr.= "\"birth_date\""; if($outstr!="") $outstr.=","; $outstr.= "\"first_name\""; if($outstr!="") $outstr.=","; $outstr.= "\"last_name\""; if($outstr!="") $outstr.=","; $outstr.= "\"gender\""; if($outstr!="") $outstr.=","; $outstr.= "\"hire_date\""; echo $outstr; echo "\r\n";// write data rows $iNumberOfRows = 0; $pageObject->viewControls->forExport = "csv"; while((!$nPageSize || $iNumberOfRows < $nPageSize) && $row) { $values = array(); $values["emp_no"] = $pageObject->getViewControl("emp_no")->getExportValue($row, ""); $values["birth_date"] = $pageObject->getViewControl("birth_date")->getExportValue($row, ""); $values["first_name"] = $pageObject->getViewControl("first_name")->getExportValue($row, ""); $values["last_name"] = $pageObject->getViewControl("last_name")->getExportValue($row, ""); $values["gender"] = $pageObject->getViewControl("gender")->getExportValue($row, ""); $values["hire_date"] = $pageObject->getViewControl("hire_date")->getExportValue($row, ""); $eventRes = true; if ($eventObj->exists('BeforeOut')) { $eventRes = $eventObj->BeforeOut($row,$values, $pageObject); } if ($eventRes) { $outstr=""; if($outstr!="") $outstr.=","; $outstr.='"'.str_replace('"', '""', $values["emp_no"]).'"'; if($outstr!="") $outstr.=","; $outstr.='"'.str_replace('"', '""', $values["birth_date"]).'"'; if($outstr!="") $outstr.=","; $outstr.='"'.str_replace('"', '""', $values["first_name"]).'"'; if($outstr!="") $outstr.=","; $outstr.='"'.str_replace('"', '""', $values["last_name"]).'"'; if($outstr!="") $outstr.=","; $outstr.='"'.str_replace('"', '""', $values["gender"]).'"'; if($outstr!="") $outstr.=","; $outstr.='"'.str_replace('"', '""', $values["hire_date"]).'"'; echo $outstr; } $iNumberOfRows++; if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs); if(((!$nPageSize || $iNumberOfRows<$nPageSize) && $row) && $eventRes) echo "\r\n"; }}function WriteTableData($rs, $nPageSize, $strTableName, $eventObj, $cipherer, $pageObject){ if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs);// if(!$row)// return;// write header echo "<tr>"; if($_REQUEST["type"]=="excel") { echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","emp_no")).'</td>'; echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","birth_date")).'</td>'; echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","first_name")).'</td>'; echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","last_name")).'</td>'; echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","gender")).'</td>'; echo '<td style="width: 100" x:str>'.PrepareForExcel(GetFieldLabel("employees","hire_date")).'</td>'; } else { echo "<td>".GetFieldLabel("employees","emp_no")."</td>"; echo "<td>".GetFieldLabel("employees","birth_date")."</td>"; echo "<td>".GetFieldLabel("employees","first_name")."</td>"; echo "<td>".GetFieldLabel("employees","last_name")."</td>"; echo "<td>".GetFieldLabel("employees","gender")."</td>"; echo "<td>".GetFieldLabel("employees","hire_date")."</td>"; } echo "</tr>"; // write data rows $iNumberOfRows = 0; $pageObject->viewControls->forExport = "export"; while((!$nPageSize || $iNumberOfRows<$nPageSize) && $row) { countTotals($totals, $totalsFields, $row); $values = array(); $values["emp_no"] = $pageObject->getViewControl("emp_no")->getExportValue($row, ""); $values["birth_date"] = $pageObject->getViewControl("birth_date")->getExportValue($row, ""); $values["first_name"] = $pageObject->getViewControl("first_name")->getExportValue($row, ""); $values["last_name"] = $pageObject->getViewControl("last_name")->getExportValue($row, ""); $values["gender"] = $pageObject->getViewControl("gender")->getExportValue($row, ""); $values["hire_date"] = $pageObject->getViewControl("hire_date")->getExportValue($row, ""); $eventRes = true; if ($eventObj->exists('BeforeOut')) { $eventRes = $eventObj->BeforeOut($row, $values, $pageObject); } if ($eventRes) { $iNumberOfRows++; echo "<tr>"; echo '<td>'; echo $values["emp_no"]; echo '</td>'; echo '<td>'; if($_REQUEST["type"]=="excel") echo PrepareForExcel($values["birth_date"]); else echo $values["birth_date"]; echo '</td>'; if($_REQUEST["type"]=="excel") echo '<td x:str>'; else echo '<td>'; if($_REQUEST["type"]=="excel") echo PrepareForExcel($values["first_name"]); else echo $values["first_name"]; echo '</td>'; if($_REQUEST["type"]=="excel") echo '<td x:str>'; else echo '<td>'; if($_REQUEST["type"]=="excel") echo PrepareForExcel($values["last_name"]); else echo $values["last_name"]; echo '</td>'; if($_REQUEST["type"]=="excel") echo '<td x:str>'; else echo '<td>'; if($_REQUEST["type"]=="excel") echo PrepareForExcel($values["gender"]); else echo $values["gender"]; echo '</td>'; echo '<td>'; if($_REQUEST["type"]=="excel") echo PrepareForExcel($values["hire_date"]); else echo $values["hire_date"]; echo '</td>'; echo "</tr>"; } if($eventObj->exists("ListFetchArray")) $row = $eventObj->ListFetchArray($rs, $pageObject); else $row = $cipherer->DecryptFetchedArray($rs); } }?>
  3. السلام عليكم ورحمة الله وبركاته برجاء المساعدة في تكملة البرنامج المطلوب في كل سجل من السجلات بالنماذج يوجد معلومات كثيرة اريد اضافتها بالوورد وفي نفس الوقت تكون مربوطه بالسجل عند الرجوع اليها مرة اخري .. وشكرا جزيلا جديد محطات.rar
  4. السلام عليكم اخواني هذا قالب ووردبريس قمت بتصميميه من الصفر بدون الاعتماد على اي قالب آخر يعني ملفات php كانت فاضية عندما انشائته و اضفت الاكواد بنفسي رابط الموقع http://pctechneon.com رابط HTML  Validating http://validator.w3.org/check?uri=http%3A%2F%2Fpctechneon.com%2F  CSS Validating http://jigsaw.w3.org/css-validator/validator?uri=http%3A%2F%2Fpctechneon.com%2F الهذف من التصميم سرعة التصفح و سهولة الاستخذام تخصص الموقع تقني اخبار و المواضيع من كتابتي  انتظر آرائكم حول تصميم الموقع و المواضيع الموجودة فيه
  5. شركة أسس برمجية تقدم أقوي العروض بوابة إلكترونية متكاملة بأستخدام احدث التقنيات HTML5 + CSS3 + Jquery ونسخة تصلح للتصفح من الجوال مع دعم فنى لموقعك لمدة 10 ايام مجانا فقط بـــ 440 ريال     إلق نظرة علي عملاء أسس برمجية أفتح تذكرة جديدة وأطلب بوابتك الإلكترونية فوراََ. أسس برمجية متخصصون فى تصميم وتطوير المواقع والبوابات الالكترونية PHP - Wordpress - Joomla - Drupal - HTML5 - CSS3 - Jquery - PHP - Asp.net