{"id":483,"date":"2015-08-28T10:48:03","date_gmt":"2015-08-28T07:48:03","guid":{"rendered":"http:\/\/www.erenali.com\/?p=483"},"modified":"2015-08-28T10:48:48","modified_gmt":"2015-08-28T07:48:48","slug":"yii-cgridviewde-id-ye-karsilik-gelen-degeri-gosterme","status":"publish","type":"post","link":"https:\/\/www.erenali.com\/index.php\/2015\/08\/28\/yii-cgridviewde-id-ye-karsilik-gelen-degeri-gosterme\/","title":{"rendered":"Yii cgridviewde id ye kar\u015f\u0131l\u0131k gelen de\u011feri g\u00f6sterme"},"content":{"rendered":"<div class=\"38128c0007b0f41e35c6013bb0abf0bf\" data-index=\"1\" style=\"float: left; margin: 10px 10px 10px 0;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-3908223554810378\"\r\n     data-ad-slot=\"5522206140\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n\n<\/div>\n<p>Gridview yap\u0131s\u0131nda direk tablodan veri \u00e7ekti\u011fimizde tablonun id de\u011feri tuttu\u011fu alanlar\u0131 i\u015fimizi g\u00f6rmeye bilir. Bu alanlar farkl\u0131 tablolarla ili\u015fkili olabilir. Bu gibi durumlarda id nin kar\u015f\u0131l\u0131k geldi\u011fi de\u011feri gridview de g\u00f6stermek i\u00e7in bir iki sat\u0131r kod eklemek yeterli olacakt\u0131r. T\u00fcm bunlardan \u00f6nce\u00a0<a href=\"http:\/\/www.erenali.com\/index.php\/2015\/08\/14\/yii-kendi-helper-dosyamizi-olusturmak\/\" target=\"_blank\">Y\u0130\u0130 KEND\u0130 HELPER DOSYAMIZI OLU\u015eTURMAK<\/a> yaz\u0131m\u0131 inceleyerek bir fonksiyon sayfas\u0131 olu\u015fturmak iyi olacakt\u0131r.<\/p><div class=\"38128c0007b0f41e35c6013bb0abf0bf\" data-index=\"1\" style=\"float: left; margin: 10px 10px 10px 0;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-3908223554810378\"\r\n     data-ad-slot=\"5522206140\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n\n<\/div>\n\n<p>\u00d6rne\u011fimde bilisimcihazlarihelper ad\u0131nda bir fonksiyon dosyas\u0131 olu\u015fturdum ve bu dosya i\u00e7inde ihtiyac\u0131m olacak olan fonksiyonlar\u0131 kullanaca\u011f\u0131m. A\u015fa\u011f\u0131daki admin.php dosyamda tablomda ki markalarid alan\u0131mda tuttu\u011fum de\u011ferin ba\u015fka bir tablodaki kar\u015f\u0131l\u0131\u011f\u0131n\u0131 almak istiyorum.<\/p>\n<p>\/view\/aaa\/admin.php<\/p>\n<blockquote>\n<h6>&lt;?php $this-&gt;widget(&#8216;zii.widgets.grid.CGridView&#8217;, array(<br \/>\n&#8216;id&#8217;=&gt;&#8217;envanter-cihazbilgi-grid&#8217;,<br \/>\n&#8216;dataProvider&#8217;=&gt;$model-&gt;search(),<br \/>\n&#8216;cssFile&#8217;=&gt;&#8217;\/css\/grid.css&#8217;,<br \/>\n&#8216;summaryText&#8217; =&gt; &#8221;,<br \/>\n&#8216;columns&#8217;=&gt;array(<\/h6>\n<h6>array(&#8216;header&#8217;=&gt;&#8217;S\u0131ra&#8217;,&#8217;value&#8217;=&gt;&#8217;$this-&gt;grid-&gt;dataProvider-&gt;pagination-&gt;currentPage * $this-&gt;grid-&gt;dataProvider-&gt;pagination-&gt;pageSize + ($row+1)&#8217;,),<\/h6>\n<h6>array(&#8216;name&#8217;=&gt;&#8217;markalarid&#8217;,&#8217;value&#8217;=&gt;&#8217;bilisimcihazlarihelper::markaadi($data-&gt;markalarid)&#8217;,&#8217;header&#8217;=&gt;&#8217;marka&#8217;,),<\/h6>\n<p>array(&#8216;name&#8217;=&gt;&#8217;okullarid&#8217;,&#8217;value&#8217;=&gt;&#8217;bilisimcihazlarihelper::okuladi($data-&gt;okullarid)&#8217;,&#8217;header&#8217;=&gt;&#8217;okul &#8216;,),<\/p>\n<h6>&#8216;ip&#8217;,<br \/>\n&#8216;port&#8217;,<\/h6>\n<p>array(&#8216;class&#8217;=&gt;&#8217;CButtonColumn&#8217;,),<br \/>\n),<br \/>\n)); ?&gt;<\/p><\/blockquote>\n<p>\u015eimdi bu fonksiyonlar\u0131 tan\u0131mlayacak olursam bilisimcihazlarihelper.php dosyas\u0131na markaadi ve okuladi olarak fonksiyonlar olu\u015fturdum. Gerekli tablolardan id de\u011ferine g\u00f6re sorgu yap\u0131p de\u011feri d\u00f6nd\u00fcr\u00fcyorlar.<\/p>\n<p>bilisimcihazlarihelper.php<\/p>\n<blockquote>\n<h6>public static function okuladi($id)<br \/>\n{<br \/>\n@$okuladi=EnvanterOkullar::model()-&gt;findbyPk($id)-&gt;bina;<br \/>\nif($okuladi)<br \/>\nreturn($okuladi);<br \/>\nelse<br \/>\nreturn &#8220;&#8221;;<br \/>\n}<\/h6>\n<h6>public static function markaadi($id)<br \/>\n{<br \/>\n@$markaadi=EnvanterMarkalar::model()-&gt;findbyPk($id)-&gt;marka;<br \/>\nif($markaadi)<br \/>\nreturn($markaadi);<br \/>\nelse<br \/>\nreturn &#8220;&#8221;;<br \/>\n}<\/h6>\n<p>b\u00f6ylece marka alan\u0131nda ki veritaban\u0131nda kay\u0131tl\u0131 10 de\u011feri markalar tablosundaki kar\u015f\u0131l\u0131\u011f\u0131 olan HP Procurve Switch 2530-48G+Poe de\u011feriyle g\u00f6sterildi. Ayn\u0131 \u015fekilde okul alan\u0131nda ki 15 de\u011feri de Sivil Havacilik olarak g\u00f6sterildi.<\/p>\n<p><a href=\"http:\/\/www.erenali.com\/wp-content\/uploads\/2015\/08\/Ekran-Al\u0131nt\u0131s\u0131.jpg\"><img loading=\"lazy\" class=\"alignnone size-medium wp-image-481\" src=\"http:\/\/www.erenali.com\/wp-content\/uploads\/2015\/08\/Ekran-Al\u0131nt\u0131s\u0131-300x113.jpg\" alt=\"Ekran Al\u0131nt\u0131s\u0131\" width=\"300\" height=\"113\" srcset=\"https:\/\/www.erenali.com\/wp-content\/uploads\/2015\/08\/Ekran-Al\u0131nt\u0131s\u0131-300x113.jpg 300w, https:\/\/www.erenali.com\/wp-content\/uploads\/2015\/08\/Ekran-Al\u0131nt\u0131s\u0131-290x109.jpg 290w, https:\/\/www.erenali.com\/wp-content\/uploads\/2015\/08\/Ekran-Al\u0131nt\u0131s\u0131.jpg 671w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p><\/blockquote>\n<div class=\"38128c0007b0f41e35c6013bb0abf0bf\" data-index=\"2\" style=\"float: none; margin:10px 0 10px 0; text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-3908223554810378\"\r\n     data-ad-slot=\"5522206140\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\r\n\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Gridview yap\u0131s\u0131nda direk tablodan veri \u00e7ekti\u011fimizde tablonun id de\u011feri tuttu\u011fu alanlar\u0131 i\u015fimizi g\u00f6rmeye bilir. Bu alanlar farkl\u0131 tablolarla ili\u015fkili olabilir. Bu gibi durumlarda id nin kar\u015f\u0131l\u0131k geldi\u011fi de\u011feri gridview de g\u00f6stermek i\u00e7in bir iki sat\u0131r kod eklemek yeterli olacakt\u0131r. T\u00fcm bunlardan \u00f6nce\u00a0Y\u0130\u0130 KEND\u0130 HELPER DOSYAMIZI OLU\u015eTURMAK yaz\u0131m\u0131 inceleyerek bir fonksiyon&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/www.erenali.com\/index.php\/2015\/08\/28\/yii-cgridviewde-id-ye-karsilik-gelen-degeri-gosterme\/\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">Yii cgridviewde id ye kar\u015f\u0131l\u0131k gelen de\u011feri g\u00f6sterme<\/span> <i class=\"fas fa-angle-right\"><\/i><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5,6],"tags":[235,234,236,233],"_links":{"self":[{"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/posts\/483"}],"collection":[{"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/comments?post=483"}],"version-history":[{"count":2,"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/posts\/483\/revisions"}],"predecessor-version":[{"id":485,"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/posts\/483\/revisions\/485"}],"wp:attachment":[{"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/media?parent=483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/categories?post=483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erenali.com\/index.php\/wp-json\/wp\/v2\/tags?post=483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}